Free COG-645 Exam Questions and COG-645 Study Guide
Enjoy Free IBM COG-645 Exam Questions. Download the Best COG-645 Cheat-Test Sample Questions.
Version: 8.5 Release Date: May, 2012
Download the Latest IBM COGNOS COG-645 Practice Test - Supported by Cheat-Test
Q: 1
Which term below best describes the selected cell in the crosstab?
A. Level
B. member
C. Tuple
D. Revenue
Answer: C
Q: 2
When would a report author define a set?
A. To create a slicer to focus on a specific number of years of data in a report.
B. To change the crosstab node member properties for a level.
C. To use as a summary function to return the total of the specified members.
D. To return members from different hierarchies of the same dimension.
Answer: A
Q: 3
What kind of authoring style uses the filter function?
A. Relational
B. Conformed
C. Dimensional
D. DMR
Answer: C
Q: 4
In a crosstab, Campaign is in the rows area, Order method type is in the columns area, and
Quantity is the measure. Campaign and Order method type are specified in the query. The report
runs, displaying quantity values for all years. Why does this happen?
A. The dimension member from that dimension is implied.
B. The order method member from that dimension is implied.
C. The aggregate member from that dimension is implied.
D. The default member from that dimension is implied.
Answer: D
Q: 5
To create a report from the data source shown, what entities will the report author use?
A. Members
B. Values
C. Attributes
D. MUNs
Answer: B
Q: 6
What is true about MUNs?
A. A MUN is a business key that allows drill through between packages.
B. A MUN is a key with a unique value at each level.
C. A MUN contains the fully qualified path to a member.
D. A MUN is a category code that is generated when the cube is built.
Answer: C
Q: 7
Assuming that Star products and Husky products are sets,
which statement below is correct about the sets in the graphic?
A. Each set is a grouping of members from different hierarchies.
B. The report creates a query for each member of the set.
C. The query displays each set as all the members of the level.
D. Each set can be sorted and aggregated.
Answer: D
Q: 8
A crosstab report has product lines in the rows, years in the columns, and revenue as the
measure. In Query Explorer, from the source tree, the report author drags the order method
Telephone to the Slicer pane. Why does the report author do this?
A. To help to set the context.
B. To create an ordered set.
C. To return only one tuple.
D. To aggregate the telephone member.
Answer: A
Q: 9
A data source has a Time hierarchy, a Products hierarchy, and a Retailers hierarchy. What are the
preferred techniques the report author would use to focus reports for this type of a data source?
A. Dimensional functions and slicers
B. Use Members directly
C. Ancestors and descendants
D. Detail filters and summary filters
Answer: A
Q: 10
Which of the following are dimensional objects?
A. Sets and query calculation
B. Query subject and relationship cardinality
C. Slicer and string function
D. Level and member
Answer: B
Q: 11
Which statement is true about MUNs?
A. They are used to define roll-up properties in a hierarchy.
B. They are used to retrieve members from the data source.
C. They change each time the package is published.
D. They are used to retrieve levels from the data source.
Answer: B
Q: 12
When a report author inserts Revenue into the Measures area of a blank crosstab report, which of
the following statements is correct?
A. The report author has implicitly set the default measure for the crosstab report to be Revenue.
B. The report author must verify the aggregation properties of Revenue to make sure it will display
correctly.
C. The report author has declared a currentMember function to return the Revenue data.
D. The report author must validate the expression for Revenue to ensure there are no crosstab
errors.
Answer: A
Q: 13
In the data source shown,
what dimensional component is selected?
A. Dimension
B. Hierarchy
C. Namespace
D. Level
Answer: B
Q: 14
The sales manager requires a crosstab report to display the top 3 sales people for the month.
Considering that an OLAP data source is used, what will the report author use when creating this
report?
A. A set expression
B. An axis title
C. A percent of base calculation
D. The hierarchize function
Answer: A
Q: 15
A report author is working with an OLAP data source. The report author creates a query that uses
a caption function on a member and applies a string function. What is a possible consequence of
this action?
A. Using these dimensional methods will not work with an OLAP data source.
B. The mapped string values will not pass through to the target report.
C. There is nothing wrong with this approach.
D. Mixing dimensional styles and relational styles in a single query can create unexpected results.
Answer: D
Q: 16
A report author can use a slicer to do what?
A. Make the report database smaller and efficient
B. Provide context to intersection values
C. Reduce the number of members on the edge of the crosstab.
D. Generate a zero suppression filter in the rows
Answer: B
Q: 17
A report author creates a crosstab as shown.
What is the default measure of the report?
A. Mountaineering Equipment
B. Camping Equipment
C. Gross profit
D. Revenue
Answer: D
Q: 18
The report author uses the filter function to focus data in a report, but the results are unexpected.
What did the report author overlook when filtering the data?
A. Relational detail
B. Products hierarchy
C. Report context
D. Root levels
Answer: C
Q: 19
When the report consumer drills through from a dimensional member to a relational data item,
what data type is passed?
A. Category code
B. Caption value
C. Member unique name
D. Business key
Answer: D
Q: 20
The "Sales" and "Inventory" data stores each have "Products" and "Time" dimensions. For drillthrough
between the data stores on the "Products" and "Time" dimensions to work, which items in
the structures must be identical in the data stores?
A. Hierarchy names, member values
B. Level order, level names
C. Hierarchy names, snowflake schema
D. Role value, internal keys
Answer: B
Q: 21
A report author creates a report with a drill-through definition. In the target report the parameter
expression is " ->?P?". What type of data must be passed to the parameter?
A. A member from the level
B. Any member from the hierarchy
C. A value
D. A business key from the level
Answer: A
Q: 22
The report author creates a source report that contains values from "Products" on which the report
consumer will drill through for details. The report author has created a target report which expects
a member from the source. Is this a supported drill-through combination?
A. Yes, this value-to-member drill-through is a supported combination.
B. No, this value-to-member drill-through is not a supported combination.
C. No, this member-to-value drill-through is not a supported combination.
D. Yes, this member-to-value drill-through is a supported combination.
Answer: B
Q: 23
A report author uses the following expression: lastPeriods(3,[2007/Mar]). What data will be
returned when the report is run?
A. The last 3 months before 2007/Mar
B. 3 months, including 2007/Mar and the preceeding 2 months
C. The total of currentMeasure for 3 months including 2007/Mar and the preceeding 2 months
D. The month March of each of the 3 years 2005, 2006, and 2007
Answer: B
Q: 24
The following expression is used to focus OLAP data in the rows of a report:
filter([sales_and_marketing].[Order method].[Order method].[Order method type],
[Revenue]>150000000).
Which of the following statements describes the purpose of the expression?
A. To return the set of members whose revenue is less than 150000000 for any year.
B. To return the set of members whose revenue is greater than 150000000 for the sum of the
opposite edge.
C. To filter the cell values by subtracting 150000000 from the revenue for each year and order
method type.
D. To filter the years to show those having revenues greater than 150000000 by order method
type.
Answer: B
Q: 25
Consumers want a report to compare the revenue and quantity sold for all product lines in a
selected quarter, to the same quarter for the previous year. They also want to see the total for
periods, up to and including the quarter selected.
Which of the following dimensional functions could the report author use to create this report?
A. Ancestor, currentMember, lead, total
B. OpeningPeriod, order, quarter, Firstsibling
C. Cousin, tuple, closingPeriod, aggregate
D. ParallelPeriod, tuple, periodsToDate, aggregate
Answer: D
Q: 26
What functionality will allow the report consumer to focus the report each time it is run?
A. Filter a MUN
B. Use a prompt
C. Build a slicer
D. Use a dimensional function
Answer: B
Q: 27
When must a report author use the caption function?
A. As the first parameter of the roleValue function.
B. To return the display name for the specified business key.
C. To see the string display name for the specified element.
D. To pass the returned value to a drill-through target report,this expects a matching string as a
parameter value.
Answer: D
Q: 28
What dimensional function is used to return the members on the level below the Product line
level?
A. Set
B. Children
C. Descendants
D. members
Answer: C
Q: 29
A report author uses an OLAP cube to create a crosstab with Revenue as a measure, the Product
line level in the rows, and the year members (2004-2007) in the columns. How can the report
author efficiently determine the difference in revenue between the years 2005 and 2006?
A. Determine MUNs for the years 2005 and 2006, and then create an expression using the MUNs.
B. Create a new column as a query calculation, and create the expression [2006]-[2005].
C. Create a set of the 2005 and 2006 members and aggregate it.
D. Ask the modeler to create a calculated category in Transformer and then use it directly.
Answer: B
Q: 30
What type of prompt would a report author use to return a set of members from a hierarchy?
A. Select and Search Prompt
B. Value prompt
C. Tree prompt
D. Prompt Page
Answer: C
Q: 31
If the syntax for the head function is head(set_exp[,index_exp]),then which of the following
expressions is correct?
A. head(members([sales_and_marketing].[Products].[Products].[Product line]),2)
B. head(([sales_and_marketing].[Products].[Products].[Product line])[,2])
C. head(order([sales_and_marketing].[Products].[Products].[Product line])2)
D. head(members([sales_and_marketing].[Products].[Products].[Product line],2))
Answer: A
Q: 32
Which of the following family functions is most similar to the relative time function parallelPeriod?
A. Cousin
B. PrevMember
C. Siblings
D. OpeningPeriod
Answer: A
Q: 33
What does the following expression do: "generate([Product
line],topCount(descendants(currentMember([sales_and_marketing].[Products].[Products]),[sales_a
nd_marketing].[Products].[Products].[Product]),2,[Revenue]))"?
A. Returns the top two products by revenue for each product line.
B. Finds the top two members by revenue at the product level and returns their respective
ancestors at the product line level.
C. Calculates the top two product lines for each product.
D. Goes two levels up from products and returns the top members by revenue at that level.
Answer: A
Q: 34
What is a key difference between the total function and the aggregate function?
A. The aggregate function can only summarize within a set, and the total function can accept
separate members.
B. The aggregate function is dimensional, and the total function is relational.
C. The aggregate function will summarize only the currentMeasure, and the total function will
summarize any specified measure.
D. The aggregate function follows the rollup rules of the measure defined in the data source, and
the total function adds the total of the specified measure.
Answer: D
Q: 35
The dialog box shown appears when a report is run.
What should the report author do to correct the situation?
A. Ask the modeler to rename the hierarchy to
'[sales_and_marketing].[Products].[Products].[Products]', and to republish the package.
B. Modify the expression to change the 'currentMember' function to 'currentLevel'.
C. Modify the expression to change the 'currentMember' function to 'currentHierarchy'.
D. Modify the expression to 'currentMember([sales_and_marketing].[Products].[Products])'.
Answer: D
Q: 36
Based on the crosstab displayed, the report author creates a singleton using the tuple function as
follows: tuple([Camping Equipment],[Revenue],[2006]).
Which of the following will appear in the singleton when the report is run?
A. Camping Equipment, 500,382,422.83, 2006
B. 500,382,422.83
C. Camping Equipment, Revenue, 2006
D. Nothing, singletons are not dimensional objects.
Answer: B
Q: 37
In a crosstab report, the report author wants a column to display a percentage of overall revenue
that a particular product contributed to.
Which of the following is a valid dimensional expression for this purpose?
A. tuple([Revenue]/[Products]*[Revenue])
B. [Revenue]/([Revenue]*[Products])
C. [Revenue]/tuple([Revenue],[Products])
D. [Revenue]/total([Revenue]for[Products])
Answer: C
Q: 38
A report author creates an expression using the closingPeriod function to return the latest month
found in the data source, and names the expression "Current Month". What can the report author
do with "Current Month"?
A. Use it to replace the lastPeriods(1,[Month]) expression currently in the report.
B. Add it to an expression to find the current member for the Month level.
C. Use it to determine the current quarter: parent([Current Month]).
D. Use it as a report expression to display the current month in the page header of the report.
Answer: C
Q: 39
Can a prompt be used in the expression of a slicer?
A. Yes, if the correct syntax is used.
B. No, the slicer syntax is not compatible with prompt syntax.
C. Yes, if the slicer is a hierarchy.
D. No, the slicer must be manually created by the report author.
Answer: A
Q: 40
Of the following prompt syntax expressions, which two are considered to be dimensional?
1) -> ??
2) in (??)
3) = ??
4) set( -> ??)
A. 1 and 4
B. 1 and 2
C. 2 and 3
D. 3 and 4
Answer: A
Q: 41
Which of the following statements is correct about the order function?
A. The currentMeasure function must be used with the order function as the sort by criterion.
B. It arranges members of all sets in the report by ascending or descending values.
C. Optional parameters allow the author to order the members of a hierarchy without regard of
their level.
D. It arranges members of a set alphabetically by ascending or descending captions.
Answer: C
Q: 42
Instead of prompting the user to select any countries in Europe, the report author wants to
constrain the user to select one or more countries from the Northern Europe region. What kind of
prompt should be used and how can this be achieved?
A. This is not possible because a prompt must always be populated with all members of a level.
B. Create a multi-select value prompt. Populate it using an expression on the [Northern Europe]
member to retrieve its children on the country level.
C. Generate a prompt by creating an expression with aparameter on the crosstab
edge:children([Northern Europe]->?Country?
D. Create a tree prompt, and populate it using an expression on the [Northern Europe] member to
retrieve its children at the country level.
Answer: B
Q: 43
Based on the diagram,
if the expression firstSibling([2006 Q 1]) is used in the report, what item will be returned?
A. 2005 Q 1
B. 2006 Q 4
C. 2006 Q 1
D. Nothing, because the return value equals the parameter
Answer: C
Q: 44
What is the default behavior when drilling down on an edge in a crosstab report?
A. The level drilled on is replaced with the entire level below it.
B. The edge expression is replaced with the children of the item drilled on.
C. All edge expressions of the crosstab are replaced with their children.
D. The edge expression is changed to another item in the query.
Answer: B
Q: 45
A report author has created a crosstab report from the data source shown. The Retailer name
level has been dragged to the rows and default drilling up and down has been activated.
What will be displayed in the report if the consumer drills up on one of the members of Retailer
name?
A. The parent member of the member drilled on.
B. The ancestors of the member drilled on from the whole Retailers hierarchy.
C. The members from the Region level.
D. The members from the Retailer country level.
Answer: D
Q: 46
The author has created a complex expression called "Sorted Products" on the row edge, which
sorts product line by Revenue for 2006.
What must the report author do to sort the members when drilling down?
A. Configure the Ancestor drill behavior on the Sorted Products expression.
B. Preserve the Sorted Products expression, but replace the underlying Product Set expression.
C. Nothing, as the default drill behavior is sufficient in this case, to maintain sorting of the children.
D. Set the behavior to Depth Based Expression, to maintain sorting at a lower level in the data
source.
Answer: B
Q: 47
The report author creates a query where two items (TopThree and Retailer country) exist in the
same member set. The expression for TopThree is: topCount([Retailer country],3,[Revenue]).
What drill behavior should the report author set in order to display the top three children instead of
all children on drill down?
A. Configure TopThree to Change Expression, and configure Retailer country to Preserve.
B. Configure TopThree to Preserve, and configure Retailer country to Preserve.
C. Configure TopThree to Preserve, and configure Retailer country to Replace Expression.
D. Configure TopThree to Ancestor, and configure Retailer country to Change Expression.
Answer: C
Q: 48
Which of the following statements is true about explicitly defined member sets?
A. They must have drill behavior defined manually.
B. They assume the drill behavior from the top member set in the same branch.
C. They are automatically configured for default drill behavior.
D. They are too complex to enable drilling.
Answer: A
Q: 49
Why would a report author consider overriding the default drill behavior?
A. To maintain the behavior of a complex edge expression after drilling, such as one whichreturns
the top 5 members of a set.
B. To replace all members within a hierarchy when drilling through to a report with more detail.
C. To drill down to the lowest level of the hierarchy and then drill down again to display only one
member.
D. To drill down on a member and have its children display as details and have the member drilled
on display as summary.
Answer: A
Q: 50
A report author creates the following nested report using 2 adjacent levels of the same hierachy.
Users should be able to drill down on the inner nesting with the outer nesting remaining
unchanged.
What advanced drilling behavior should the report author use to achieve this?
A. Replace Expression
B. Depth Based Expression
C. Preserve
D. Replace Item
Answer: C
Q: 51
Which of the following is true if a report author nests members in a crosstab report?
A. Nested members are also known as complex members.
B. The inner member must be on the level immediately below the outer member.
C. Nested members must be members of hierarchies, not of the Measures folder.
D. It is possible to nest members from different dimensions.
Answer: D
Q: 52
The report author wants to create a report to compare the sales of product types for special sales
promotions in 2005 and 2006, but the report will exclude regular sales. Which style of authoring
and which function will the report author use to create this report from a cube data source?
A. Relational authoring style, except function
B. Dimensional authoring style, filter function
C. Dimensional authoring style, except function
D. Relational authoring style, filter function
Answer: C
Q: 53
Which of the following statements is true about a slicer?
A. It keeps the summary column in the report, and removes the detail columns.
B. It affects the values of the cells of the report but not the rows or columns.
C. It determines which set of members are displayed on the edges of the report.
D. It removes all blank rows in the report to make it more focused.
Answer: B
Q: 54
A report author creates a revenue report from an OLAP data source. On the rows, there are
nested levels, each from different dimensions having a large number of members. The report
author filters out empty rows using the expression "[Revenue] > 0". When running this report,
there is poor performance. What could cause this?
A. There are too many members or levels nested on the row edge.
B. Filtering on measure values is incompatible with an OLAP data source.
C. Limiting the crosstab measures with a filter function.
D. A relational filter was applied.
Answer: D
Q: 55
To display all individual campaigns in a crosstab report, a report author could use the expression
set([TrailChef Campaign],[EverGlow Campaign],[Course Pro Campaign]). Instead, the report
author decides to use the parent member of the campaigns in the set expression "children([All
Campaigns])". Which statement is true about the method that was used?
A. In the future, when a campaign is deleted or new ones are added, the report author must
modify the expression.
B. In the future, when a campaign is deleted or new ones are added, the unmodified expression
will be valid.
C. The report author should not have used the method chosen, as the first method is best in this
situation.
D. To be accurate, the report author should avoid using a set expression.
Answer: B
Q: 56
A report runs, and is 433 pages long, with 19,010 rows. Many of the rows are blank. The report
author uses a filter function to filter nulls, and runs the report again. The result is 143 pages, with
6273 rows, and none of the rows are blank. What filtering style did the report author decide to
use?
A. Conventional
B. Dimensional
C. Relational
D. Functional
Answer: B
Q: 57
The following expression is used in a crosstab report: filter([sales_and_marketing]. [Product
brand].[Product brand].[Product brand type],[Revenue]<100000000 26="26" are="are" brand="brand" p="p" product="product" there="there">
types in the OLAP data source.
Why does the report only return 11 product brand type rows?
A. A relational function was used to filter on the measure values, not the members.
B. A dimensional function was used to filter on each column.
C. A relational function was used to filter on the members, not the measure values.
D. A dimensional function was used to filter on the total of the opposite edge.
Answer: D
Latest Version: 9.5 Last Update: December, 2012
Need the Latest version of COG-645 Exam Prep Or the other IBM Exam Prep, Visit the Cheat-Test.com Official website.
COG-645,COG-645 exam,COG-645 dumps,COG-645 study guide,COG-645 practice test,IBM COG-645
Comprehensive questions with complete details
