What data structure?
The database table below would typically be found in what data structure? A. Cartesan B. Normalized C. Operational D. Star schema
The database table below would typically be found in what data structure? A. Cartesan B. Normalized C. Operational D. Star schema
Which of the following is true of an OLAP data structure? A. Comprised of normalized dimension and fact structures. B. Organizes dimension tables into hierarchies and levels. C. Allows "real time" analysis against disparate data sources. D. Cardinality must be…
What question should a data modeler answer before accepting this proposed operational data structure? A. Should all three tables be consolidated into one? B. Should a role playing dimension be created? C. Are Branch and Employee dimension tables or fact…
Which of the following data structures typically contain normalized data? A. Cube B. Relational C. Operational D. Data Warehouse
In Framework Manager, it is recommended to model operational metadata as a virtual star schema for which one of the following reasons? A. Provides stability to the underlying data structure. B. Creates an easy-to-read data dictionary for end users. C.…
In Framework Manager, role-playing dimension query subjects are used to resolve which reporting trap? A. Unwanted query splits (full outer joins). B. One query subject with several relationships. C. Multiple ambiguous joins between two query subjects. D. Queries that reference…
What must a modeler consider when modeling for drill-through between multiple data sources? A. Drill-through values must be cast. B. Drill-through values must be conformed. C. Drill-through values must be consolidated. D. Drill-through values must be identifiers.
Which of the following is true when applying object security in Framework Manager? A. If beginning to apply security by specifying object security on an object with no children, all other objects remain accessible to all users. B. If beginning…
Which of the following join types does the generated SQL below illustrate? A. Inner join B. Disjointed join C. Outer join D. Cross join
An author creates a Report Studio report that contains Month, Product Line and Revenue. Revenue has a footer to show the overall total. What will the author see in the generated Cognos SQL for the Revenue footer column? A. XSUM(Sales_Fact.Revenue…