質問 1：
An Employee hierarchy has been created using the Hierarchy wizard. However, employee names now need to be included in the hierarchy. What should be done?
A. Select the hierarchy and rerun the Hierarchy wizard to add an attribute to it.
B. Create another dimension build to populate the hierarchy with an Employee Name attribute.
C. Add a derivation to the dimension build to include Employee Name.
D. Manually add the Employee Name attribute to the template and to the hierarchy.
正解：D
質問 2：
Which of the following is are characteristics of surrogate keys? (choose three)
A. Are numbers.
B. Have no intrinsic meaning.
C. Are unique.
D. Are text-based.
E. Tend to be larger than keys from operational systems.
F. Are replaced by business keys in the data warehouse.
正解：A,B,C
質問 3：
When executing a fact build, a developer wants to estimate the amount of input resources that the build will require, but does not want to deliver any data. What execution mode should be selected?
A. Preproduction
B. Object Creation
C. Test
D. Check Only
正解：D
質問 4：
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?
A. Derived dimension
B. Data source derivation
C. DataStream derivation
D. Derived measure
正解：A
質問 5：
Incoming fact data includes an audit reference column for each row. This column has been identified as an attribute in the transformation model. When executed, the fact build should designate this element as a key in the resulting fact table. This fact table will be created (not updated) by the fact build. What should the developer do?
A. Specify the column as a key in the data source properties.
B. Specify the column as a key in the table delivery properties.
C. Convert the attribute element into a derived dimension element.
D. Convert the attribute element into a derivation element.
正解：B
質問 6：
Several conformed dimensions have been defined and must now be delivered to the data warehouse. Which is the best way to do this?
A. Deliver the dimension tables as part of a metadata collection.
B. Create a metadata dimension and add it to a metadata star.
C. Deliver the dimension tables through dimension builds.
D. Run the necessary CREATE TABLE statements in SQLTXT.
正解：C
An Employee hierarchy has been created using the Hierarchy wizard. However, employee names now need to be included in the hierarchy. What should be done?
A. Select the hierarchy and rerun the Hierarchy wizard to add an attribute to it.
B. Create another dimension build to populate the hierarchy with an Employee Name attribute.
C. Add a derivation to the dimension build to include Employee Name.
D. Manually add the Employee Name attribute to the template and to the hierarchy.
正解：D
質問 2：
Which of the following is are characteristics of surrogate keys? (choose three)
A. Are numbers.
B. Have no intrinsic meaning.
C. Are unique.
D. Are text-based.
E. Tend to be larger than keys from operational systems.
F. Are replaced by business keys in the data warehouse.
正解：A,B,C
質問 3：
When executing a fact build, a developer wants to estimate the amount of input resources that the build will require, but does not want to deliver any data. What execution mode should be selected?
A. Preproduction
B. Object Creation
C. Test
D. Check Only
正解：D
質問 4：
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?
A. Derived dimension
B. Data source derivation
C. DataStream derivation
D. Derived measure
正解：A
質問 5：
Incoming fact data includes an audit reference column for each row. This column has been identified as an attribute in the transformation model. When executed, the fact build should designate this element as a key in the resulting fact table. This fact table will be created (not updated) by the fact build. What should the developer do?
A. Specify the column as a key in the data source properties.
B. Specify the column as a key in the table delivery properties.
C. Convert the attribute element into a derived dimension element.
D. Convert the attribute element into a derivation element.
正解：B
質問 6：
Several conformed dimensions have been defined and must now be delivered to the data warehouse. Which is the best way to do this?
A. Deliver the dimension tables as part of a metadata collection.
B. Create a metadata dimension and add it to a metadata star.
C. Deliver the dimension tables through dimension builds.
D. Run the necessary CREATE TABLE statements in SQLTXT.
正解：C
0 お客様のコメント