C2090-180 무료 덤프문제 온라인 액세스

Which of the following is a key difference between MDX and SQL?

• A.MDX is used for dimensional style reporting while SQL is incapable of dimensional style reporting.
• B.Dimensionally Modeled Relational (DMR) retrieves data using MDX, not SQL.
• C.MDX can reference metadata that SQL cannot.
• D.MDX has built in functions to support relative date calculations while SQL cannot perform relative date calculations.

Which of the following is a common mistake made by designers when creating dimension models?

• A.Including alternate hierarchies.
• B.Adding dimensions and measures from other subject areas.
• C.Splitting a single dimension into multiple dimensions.
• D.Including multiple date/time hierarchies.

After a BI application is placed into production, all of the following are considered part of the process to prepare for the next iteration of the application, EXCEPT:

• A.periodicallyre-apply the V-test model against the developed components
• B.record and track enhancement requests
• C.communicate with users to insure the application is delivering value
• D.enhance application documentation to reflect errors and omissions

Which of the following is a critical component in delivering Corporate Performance Management throughout an enterprise?

• A.Event management designed to monitor the status of Key Performance Indicators.
• B.Star schema data marts designed to facilitate analysis and reporting.
• C.Drill across from one subject area to another through conformed dimensions.
• D.Drill down from summary to detailed information within individual subject areas.

Which of the following describes how Cognos 8 works with aggregate aware tables in relational data sources?

• A.Cognos 8 redirects its generated SQL to take advantage of aggregate aware tables.
• B.Cognos 8 can create aggregate aware tables within the database.
• C.Cognos 8 can monitor reports that are run and suggest aggregate aware tables.
• D.Cognos 8 does not make any specific adjustments for aggregate aware tables.