In Framework Manager, which of the following will have a negative impact on query performance?
A. Ensure that, where required, queries are executed against materialized views which contain only aggregated data rather than base tables that contain all the data.
B. Set the Cross-product joins and Outer Joins governors to Deny.
C. Add filters and calculations to model query subjects rather than data source query subjects.
D. Enable the Allow Enhanced Model Portability governor.
正解:D
質問 2:
Which of the following are proven practices for organizing the objects in a project?
A. When importing metadata from more than one data source, do not override the relationships defined between the data sources at the time of import.
B. When importing metadata from more than one data source, include all imported objects in the root namespace.
C. When importing metadata from more than one data source, create a separate folder for the imported objects from each data source.
D. When importing metadata from more than one data source, create a separate namespace for the imported objects from each data source.
正解:D
質問 3:
In Framework Manager, which of the following is a correct technique for maintaining packages?
A. Edit the contents of a package by including or excluding model objects such as namespaces, folders, and query subjects.
B. Perform an impact analysis on a package to identify the impact of changing the cardinality of a relationship between two query subjects included in the package.
C. Publish packages to the network as well as to the content store in order to maintain model versioning and prevent report errors.
D. When publishing packages, use file system version control so that reports created based on one version of a model will always run against that same version of the model regardless of how many times the package is published.
正解:A
質問 4:
What is true of a Framework Manager model of an operational database lacking a time dimension?
A. Report authors cannot create multi-fact, time-based queries.
B. Time-based rollups for multi-fact queries may be difficult to handle.
C. Virtual star schema models require a time dimension for multi-fact queries.
D. Report authors cannot create multi-fact, time-based queries unless using a union.
正解:B
質問 5:
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. Defining multiple connections to the data source.
C. Generating relationships based on existing primary and foreign key relationships in the database.
D. Specifying the usage property for generated query items.
正解:C
神戸** -
電車などの隙間時間もデスクでも、効率よくBI0-132学習できそうです。