QUESTION NO: 1
Where can a developer define variables in Data Manager?
Where can a developer define variables in Data Manager?
Correct Answer: B
Vote an answer
QUESTION NO: 2
When creating dimensions, what is commonly used to track historical changes?
When creating dimensions, what is commonly used to track historical changes?
Correct Answer: D
Vote an answer
QUESTION NO: 3
A developer wants to execute a fact build in a test environment. In order to ensure optimum performance, the developer wants to see messages related to resource usage (such as paging information), in case the build needs to be modified. What type of messages are these?
A developer wants to execute a fact build in a test environment. In order to ensure optimum performance, the developer wants to see messages related to resource usage (such as paging information), in case the build needs to be modified. What type of messages are these?
Correct Answer: D
Vote an answer
QUESTION NO: 4
Several conformed dimensions have been defined and must now be delivered to the data warehouse. Which is the best way to do this?
Several conformed dimensions have been defined and must now be delivered to the data warehouse. Which is the best way to do this?
Correct Answer: B
Vote an answer
QUESTION NO: 5
Which of the following is true of packages in Data Manager?
Which of the following is true of packages in Data Manager?
Correct Answer: A
Vote an answer
QUESTION NO: 6
In this JobStream, the action on failure setting for the SiteDim node has been set to TERMINATE.
What will happen if this node fails while the JobStream is executing?
In this JobStream, the action on failure setting for the SiteDim node has been set to TERMINATE.
What will happen if this node fails while the JobStream is executing?
Correct Answer: C
Vote an answer
QUESTION NO: 7
What is a difference between a measure element and an attribute element?
What is a difference between a measure element and an attribute element?
Correct Answer: B
Vote an answer
QUESTION NO: 8
The following hierarchy has been created:
Before executing the dimension build, the developer wants to ensure that duplicate rows are
excluded from each hierarchy level. If any duplicates are encountered, the developer only wants to keep the row from DataSource1. The data sources will be executed in series. What should be done?
The following hierarchy has been created:
Before executing the dimension build, the developer wants to ensure that duplicate rows are
excluded from each hierarchy level. If any duplicates are encountered, the developer only wants to keep the row from DataSource1. The data sources will be executed in series. What should be done?
Correct Answer: D
Vote an answer
QUESTION NO: 9
A developer wants to ensure that the business keys in incoming source data are replaced with surrogate keys in the fact tables. To do this, what must be modified?
A developer wants to ensure that the business keys in incoming source data are replaced with surrogate keys in the fact tables. To do this, what must be modified?
Correct Answer: D
Vote an answer