IBM C2020-625 問題集

質問 1：
A developer has created a fact build to process the incoming data shown in the table:

The developer wants to create a monthly summary fact table. If the aggregate behavior for the Credit Limit column is set to LAST, what will be the value of Credit Limit for the first row delivered for Customer 2?
A. 1100
B. 500
C. 1200
D. 1500
正解：C

質問 2：
What can Data Manager be used for?
A. To build an IBM Cognos Planning application.
B. To extract operational data from multiple sources.
C. To create a metric store.
D. To create a content store.
正解：B

質問 3：
What can be done to minimize memory consumption?
A. Enable dimension breaking on the fact build.
B. Enable auditing on the fact build.
C. Disable fact build logging.
D. Disable dimension breaking on the fact build.
正解：A

質問 4：
In which Data Manager object does a developer specify the attributes of a conformed dimension, such as the surrogate keys that it contains?
A. Reference dimension
B. Transformation model
C. Template
D. Connection
正解：C

質問 5：
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 3, non-standard
C. Type 1
D. Type 2, non-standard
正解：C

質問 6：
A developer wants to create a connection to a database in a Data Manager catalog. When creating this connection, which of the following must the developer specify?
A. Location of the .ctg file..
B. Names and port numbers of for Data Manager socket servers.
C. Method used to connect to the database.
D. A default schema name.
正解：C

質問 7：
When this JobStream is executed,

what is the maximum number of nodes that will run in parallel at any one time?
A. 3
B. 8
C. 4
D. 7
正解：C

質問 8：
Without modifying any of the settings,

what is the lowest level of granularity that will be shown in the Reference Explorer?
A. SalesStaff
B. Staff (H)
C. Staff
D. AllStaff
正解：C

質問 9：
What distinguishes an OLTP system from a data warehouse? (choose two)
A. A data warehouse captures and processes original business transactions, while an OLTP system does not.
B. An OLTP system captures and processes original business transactions, while a data warehouse does not.
C. An OLTP system is used to transform, clean, and combine operational data, while a data warehouse is not.
D. A data warehouse is fully normalized, while an OLTP system is fully denormalized.
E. A data warehouse is fully denormalized, while an OLTP system is fully normalized.
正解：B,E