Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

IBM COG-645 Exam -

Free COG-645 Sample Questions:

Q: 1
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: 2
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: 3
In the data source shown, what dimensional component is selected?
A. Dimension
B. Hierarchy
C. Namespace
D. Level
Answer: B

Q: 4
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: 5
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: 6
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

© 2014, All Rights Reserved