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. User reporting requirements - Query performance - Data volume - DB Maintenance






2. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






3. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






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






5. Enables you to lock column headers so that they always appear when scrolling






6. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy






7. Facts associated to different column names in 2 or more tables






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






9. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.






10. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.






11. An environment in which the MSTR Desktop connects directly to the Metadata database.






12. The logical associations between attributes that exist based on a business rule






13. Descriptive data that provides context for Facts.






14. OLTP data storage measure






15. Tables - Facts - Attributes - Hierarchies






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






17. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.






18. Template - Filter - View of a Report






19. To define the level of aggregation for a specific metric - Used for qualifications






20. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






21. You can _____________ in the Architect Graphical Interface.






22. The default entry-points.






23. Compound - Homogeneous - Heterogeneous






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






25. A shortcut to an existing Object in a Project






26. Facts - Attributes - Hierarchies






27. Create the Project Source - Create the Database Instance






28. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling






29. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






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






31. Simple - Compound - Nested - Derived






32. 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.






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






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






35. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format






36. View Filters are saved with the _____________.






37. Contains info that facilitates the transfer of data from the source systems to the data-warehouse






38. A development environment to create BI applications - allowing users to edit the Metadata database






39. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)






40. The Attribute Form maps to different column names in multiple tables






41. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






42. A Project Source can house ________ . A single Metadata can be used by multiple Projects.






43. Enables you to format report values based on a condition - such as highlights - font colors - etc.






44. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






45. Subtotals reflect accumulations at selected attribute levels






46. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier






47. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.






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






49. OLAP data storage measure






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