C2020-625 by IBM Actual Free Exam Q&As

Question 1

When delivering fact data to a text file, what can be specified?

A. Default text editor to use with the file B. Maximum number of rows to be stored in the file C. Line and field delimiters D. Whether the file is in ASCII or EBCDIC format

Discussion 0

Correct Answer: C Vote an answer

Question 2

To reduce memory usage, what should be done when setting up dimension breaking for a fact build?

A. Disable late arriving facts processing for the fact build. B. Specify at least one aggregate rule for each dimension element for which breaking is enabled. C. Ensure that each data source is sorted by the same set of dimensions, in the same sequence. D. Disable the hash table and page pool for the fact build.

Discussion 0

Correct Answer: C Vote an answer

Question 3

A developer is working with the following relational table data source:

What should be done?

A. Define how the data will be pivoted in the DataStream of the fact build. B. Create a user-defined function to flip the rows and columns. C. Define how the data will be pivoted in the Delivery of the fact build. D. Create an output filter to flip the rows and columns.

Discussion 0

Correct Answer: A Vote an answer

Question 4

What can be seen with Reference Explorer that cannot be seen when using SQLTerm to examine the data?

A. Number of rows in the data source used to build the hierarchy. B. Columns from which the member data was obtained. C. Hierarchical data from two database connections. D. Number of tables in the data source used to build the hierarchy.

Discussion 0

Correct Answer: C Vote an answer

Question 5

A developer wants to create a connection to a published Framework Manager package in a Data Manager catalog. Before this connection can be created successfully, what must the developer do?

A. Log on to Cognos Connection as a user in the Data Manager Authors role. B. Add an LDAP or NTLM namespace in Cognos Configuration. C. Create a data source connection to the Cognos 8 data store. D. Configure Data Manager to access the Cognos 8 Gateway and Dispatcher URLs.

Discussion 0

Correct Answer: D Vote an answer

Question 6

Some incoming fact data has invalid product codes. The developer wants to accept this fact data and assign the necessary surrogate keys in the dimension table. What can be done to accomplish this?

A. Accept unmatched member identifiers in the dimension element properties and save unmatched member details via reference structure. B. Accept unmatched member identifiers in the measure element properties. C. Modify the SQL for the reference structure to exclude the missing product codes. D. Add a derived dimension element to the fact build to store the missing product codes and unsubscribe the element from the delivery module.

Discussion 0

Correct Answer: A Vote an answer

Question 7

A dimension table tracks employee data. If an employee's phone number changes, the old phone number does not need to be kept. What kind of change is this?

A. Type 2 B. Type 1 C. Type 2, non-standard D. Type 3, non-standard

Discussion 0

Correct Answer: B Vote an answer

Question 8

When this JobStream is executed,

what is the maximum number of nodes that will run in parallel at any one time?

A. 3 B. 4 C. 8 D. 7

Discussion 0

Correct Answer: B Vote an answer

Question 9

In which Data Manager object does a developer specify the attributes of a conformed dimension, such as the surrogate keys that it contains?

A. Transformation model B. Connection C. Template D. Reference dimension

Discussion 0

Correct Answer: C Vote an answer

IBM Cognos 10 BI Data Warehouse Developer - C2020-625 Exam Practice Test