After metadata is imported into Framework Manager or a new query subject is created, it is recommended to first verify which one of the following property settings?
A. Aggregate
B. Usage
C. Semi-Aggregate
D. Data Type
正解:B
質問 2:
In Framework Manager, what are the minimum requirements to implement a stored procedure that expects arguments and make it available to authors?
A. Import the stored procedure, provide values that satisfy the procedure's arguments, retrieve a projection list and then publish it as part of a package.
B. Import the stored procedure, add it as a model calculation, and then publish it as part of a package.
C. Import the stored procedure, set the type to Data Modification, provide values that satisfy the procedure's arguments, retrieve a projection list and then publish it as part of a package.
D. Import the stored procedure, use it to create a calculation in the expression editor and then publish the calculation as part of a package.
正解:A
質問 3:
When importing metadata into Framework Manager from a relational database, which of the following can be controlled by the modeler performing the import?
A. Converting inner joins in the database to outer joins in the model.
B. Generating relationships based on existing primary and foreign key relationships in the database.
C. Specifying the usage property for generated query items.
D. Specifying the item names in various languages.
正解:B
質問 4:
In Framework Manager, if a modeler tests the Month from Time Dimension and SALE_TOTAL from Sales Fact and applies Auto Sum, which of the following is a modeler most likely to see?
A. An XSUM on Month.
B. An XSUM on SALE_TOTAL.
C. An XMIN on Month.
D. An XMIN on SALE_TOTAL.
正解:B
質問 5:
The database table below would typically be found in what data structure?
A. Operational
B. Star schema
C. Normalized
D. Cartesan
正解:B