Test your basic knowledge |

Certified Project Designer Cpd

Instructions:
  • Answer 50 questions in 15 minutes.
  • If you are not ready to take this test, you can study here.
  • Match each statement with the correct term.
  • Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






2. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






3. A user interface for creating and maintaining a BI environment






4. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents






5. Attribute Creation Wizard - Attribute Editor






6. It contains links to specific folders in the Folder List






7. ID columns - Description columns - Fact columns






8. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






9. Enables you to rearrange the columns and rows in a report.






10. The System Hierarchy is automatically updated whenever you make a change to an __________________.






11. Subtotals reflect accumulations at selected attribute levels






12. The unique values of an attribute obtained from the data-warehouse






13. Enables you to select and display subsets of a report as separate pages.






14. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.






15. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






16. A new tool for project design tasks - used for fine-tuning a project after initial creation






17. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition






18. It contains the ID column of all higher-level attributes






19. Level of OLAP integration






20. Columns - Tables






21. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






22. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).






23. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






24. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






25. Enables you to select which tables from the data-warehouse to store in the Metadata database






26. Descriptive data that provides context for Facts.






27. Specifies a condition data must meet in order to be included in a report






28. Prompts to select a single value on which to qualify a date - number or text string.






29. OLTP retains data ________






30. Metrics you create within a report using only those objects in the report.






31. Store info on relationships between 2 or more tables (attributes) - like an Index table.






32. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications






33. Using the Prompt Generation Wizard - Inside the Report Editor






34. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






35. OLAP Services does not add any ______ to the report query.






36. Facts - Attributes - Hierarchies






37. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked






38. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.






39. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.






40. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






41. It contains the ID and DESC columns of all higher-level attributes






42. You can e-mail reports by going to _____






43. Facts associated to the same column name in 1 or more tables






44. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






45. A method of organizing the appearance of report results in a Grid report based on a criteria






46. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner






47. User requirements - Existing source data - Technical and performance considerations






48. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.






49. All Attributes must have an _______.






50. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression