Vendor: IBM
Exam Code: C2020-642
Exam Name: IBM Cognos 10 BI Scorecard Developer
QUESTION 1
What must be done to load the data successfully into Metric Studio using structured query language (SQL) scripts?
A. Perform the task Recalculate metric store derived values after each script execution.
B. Perform the task Import data from files into staging area after each script execution
C. Structure the query language to map data from the relational database to the content store.
D. Structure the query language to map data from the relational database to the staging tables
Answer: D
QUESTION 2
Which tile extension must be used on the tab-delimited file that defines relationships between objects?
A. .cmo
B. .cmr
C. .cml
D. .cmm
Answer: C
QUESTION 3
A tab-delimited file with a cmo extension can be used to create what type of object?
A. Scorecards
B. Metric types
C. Calendar levels
D. Permissions
Answer: A
QUESTION 4
An administrator attempted to transfer metric values from the staging area into the metric store. However, not all of the metrics were populated with expected values. In which table can the administrator locate the rejected rows for review, correction, and reloading?
A. KPI_VALUE_STAGE_REJECTS
B. OBJECT_STAGE_REJECTS
C. METRIC_TYPE_STAGE_REJECTS
D. OBJECT_NOTE_STAGE_REJECTS
Answer: A
QUESTION 5
How would the scorecard developer delete the Marketing scorecard and move its children under the Corporate scorecard?
A. In the user interface, drag the children to the Corporate scorecard and then delete the
Marketing scorecard.
B. In the user interface, mark the Marketing scorecard for deletion, drag the Corporate
scorecard and run re-calculate metrics derived values.
C. In the .cmo file, re-assign the parent to the children scorecard and then mark the Marketing
scorecard for deletion.
D. In the .cmdfile. re-assign the parent to the children scorecard and then mark the Marketing
scorecard for deletion.
Answer: C
QUESTION 6
A tab-delimited file with a cmm extension contains what type of objects?
A. Metrics
B. Metric types
C. Metric values
D. Import sources
Answer: B
QUESTION 7
Which statement is true about staging tables?
A. Staging tables map to Data Manager Tables
B. Staging tables map to tab-delimited files
C. Staging tables map to tables in the data warehouse
D. Staging tables map to tables in the content store
Answer: B
If you want to pass IBM C2020-642 successfully, donot missing to read latest lead2pass IBM C2020-642 exam questions.
If you can master all lead2pass questions you will able to pass 100% guaranteed.