Which of the following is true of the generated native SQL below?
A. The outer projection list will return more columns than listed, due to extra columns retrieved in the derived table.
B. The parent select statement uses an inner join to directly match columns from physical tables in the database.
C. The derived table is executed independently, using Pass-Through SQL, and then processed locally.
D. The derived table is used to retrieve one data set, in order to fulfill the join condition of another data set.
正解:D
質問 2:
In Framework Manager, which of the following is true about verifying your model?
A. It is possible to select to automatically repair certain issues that have been detected.
B. The model can be verified from Cognos Connection or through the Publish Packages wizard.
C. The model can only be verified through the Publish Packages wizard.
D. The entire model must be verified, individual objects cannot be verified.
正解:A
質問 3:
What technique can Framework Manager modelers use to implement a time dimension for models that lack a time dimension?
A. Use the Time Dimension wizard to generate a time dimension and create the appropriate relationships.
B. Use parameter maps to map date values in one query subject to date values in another query subject.
C. Identify a time dimension table source, import into the model and create relationships to fact query subjects.
D. Create relationships from date fields in one dimension to date fields in another dimension.
正解:C
質問 4:
Which of the following is true regarding the operational data structure illustrated below?
A. The cardinality between the tables should be reversed.
B. It should be consolidated into one table.
C. It illustrates a parallel relationship.
D. It should be examined for a connection trap.
正解:D
質問 5:
In a transitive relationship scenario, what problems exist when reporting from the tables below?
A. The Order table must be included in each query.
B. The Order Detail table has conflicting cardinalities.
C. The priority path must be defined.
D. There is more than one possible path between the tables.
正解:D
Yoshino -
Pass4Testのこの試験対策書はわかりやすく大変助かった。2週間で合格した。これからも他の試験を受ける予定ですが、またよろしくね。