A JobStream has been created that, when executed, will write status messages to the log file that indicate whether nodes have completed or failed to run. What type of node should be added to the JobStream?
Answer : C
Which of the following is true of conformed dimensions? (choose two)
Answer : B,E
A developer has created a hierarchy that uses multiple data sources. The developer wants to know if there are multiple parents or children without parents. What tool should the administrator use?
Answer : D
What is a difference between a measure element and an attribute element?
Answer : D
Incoming records show the number of drink packs sold by date. This information is referenced by lookups. Each drink pack contains two or more individual drinks. The developer wants to add a column to the fact table that shows how many individual drinks have been sold, not how many drink packs have been sold. What should be created to accomplish this?
Answer : D
A developer wants to be able to re-use a gross profit calculation in multiple builds. What should be created?
Answer : B
During execution, a fact build generated the following messages in the log file:
What can be done to avoid seeing the last three lines when the build is executed again?
Answer : A
A fact build has two data sources that need to undergo the same calculation for every input row, and the data will be merged. Where should the derivation be created?
Answer : A
When creating a lookup, what must be specified?
Answer : C
A developer is attempting to test a derivation.
In the Input values section, what does the cross symbol beside Price indicate?
Answer : D
Where can a variable be declared?
Answer : A
A developer has geographical data from a data source where cities roll up into states, and states roll up into regions. What should the developer create in order to allow Data
Manager to aggregate fact data to the region level?
Answer : D
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?
Answer : C
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?
Answer : B
Which of the following is true of the Navigator?
Answer : B
Have any questions or issues ? Please dont hesitate to contact us