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?
A. Data Manager will stop all processing of all nodes in the JobStream, even if they are currently running.
B. Data Manager will stop processing the SiteDim node, but will continue to process the remaining dimension build nodes.
C. Data Manager will remove the SiteDim node from the JobStream and restart the execution process.
D. Data Manager will immediately stop processing the remaining dimension build nodes, and process the fact build node instead.
正解:B
質問 2:
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. Method used to connect to the database.
B. Location of the .ctg file..
C. Names and port numbers of for Data Manager socket servers.
D. A default schema name.
正解:A
質問 3:
How can a developer nest a JobStream within another JobStream?
A. Execute the first JobStream using the Data Movement Service, and include the second JobStream in the resulting task.
B. Add a procedure node to the JobStream.
C. Execute the first JobStream from the command line, and reference the second JobStream in the command.
D. Add a JobStream node to the JobStream.
正解:D
質問 4:
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?
A. Hierachy wizard
B. SQLTerm
C. Navigator
D. Reference Explorer
E. SQLTXT Designer
正解:D
質問 5:
A developer wants to deliver fact data to a relational table. When the fact build is executed, any new rows must be added to this table. However, if an incoming row has the same key as a row that already exists in this table, the existing row must be updated accordingly. What should the developer do?
A. Set the refresh type for the relational table delivery module to APPEND.
B. Set the refresh type for the relational table delivery module to UPDATE.
C. Set the refresh type for the relational table delivery module to UPDATE/INSERT.
D. Set the refresh type for the relational table delivery module to INSERT.
E. Set the refresh type for the relational table delivery module to TRUNCATE.
F. Set the refresh type for the relational table delivery module to REPLACE.
正解:C
質問 6:
Which would be reasons for modifying a hierarchy that was previously created using the Hierarchy wizard? (Choosetwo)
A. To specify a fact build for the hierarchy.
B. To specify a metadata dimension for the hierarchy.
C. To add a level to the hierarchy.
D. To add a measure element to the hierarchy.
E. To add a derived dimension element to the hierarchy.
F. To add an attribute to a hierarchy level.
正解:C,F
質問 7:
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. Modify the SQL for the reference structure to exclude the missing product codes.
B. Accept unmatched member identifiers in the measure element properties.
C. Add a derived dimension element to the fact build to store the missing product codes and unsubscribe the element from the delivery module.
D. Accept unmatched member identifiers in the dimension element properties and save unmatched member details via reference structure.
正解:D
質問 8:
Where can a variable be declared?
A. In a Data Manager folder.
B. In a hierarchy.
C. In a data source connection.
D. In a build specification.
正解:D
Sakai -
かなりの的中率でした。ありがとうございました。C2090-625が無事で合格しました。ほぼ出題されました。