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
質問 2:
Which of the following data structures typically contain normalized data?
A. Relational
B. Operational
C. Data Warehouse
D. Cube
正解:B
質問 3:
In Framework Manager, why is it recommended that modelers alter the default all-inclusive select statements of data source query subjects as little as possible?
A. To prevent the exclusion of columns from a table that may be required in future reports.
B. To generate the most efficient SQL at run time and simplify model maintenance.
C. To provide authors with access to all columns in a databasetable which reduces requests to the modeler?
D. To prevent improperly constructed SQL and reduce issues with model documentation and readability.
正解:B
質問 4:
Which of the following is true for 0..n cardinality?
A. The cardinality is required and an outer join will be performed.
B. The cardinality is optional and an outer join will be performed.
C. The cardinality is optional and an inner join will be performed.
D. The cardinality is optional and a union will be performed.
正解:B
質問 5:
In Framework Manager, which of the following will have a positive impact on query performance without intervention from an author?
A. Add performance indicators to functions.
B. For a query item having an integer data type, set the Display Item Reference property to display an integer value.
C. Create stand-alone filters.
D. Configure data sources in a project pointing to the same database instance to use the same connection.
正解:D