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. Specifies a condition data must meet in order to be included in a report






2. Folder List - Object Viewer - Shortcut Bar






3. The Attribute Form maps to the same column name in multiple tables






4. View Filters are saved with the _____________.






5. The default entry-points.






6. Metrics aggregate on the lowest-level attribute __________.






7. Template - Filter - View of a Report






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






9. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters






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






11. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






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






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






14. You must select "Other directions" when drilling attributes while viewing a report






15. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts






16. Formula - Level (Dimensionality) - Conditionality - Transformation






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






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






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






20. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






21. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities






22. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






23. Schema Objects - Application Objects - Configuration Objects






24. Metrics that perform multiple aggregations; one calculation inside of another.






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






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






27. Creating multiple attributes quickly. Used during the initial project creation.






28. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)






29. Primary keys






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






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






32. All report-level options overwrite ___________.






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






34. Less storage - Simple SQL - Complex ETL






35. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






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






37. User reporting requirements - Query performance - Data volume - DB Maintenance






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






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






40. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






41. Used to "fine-tune" your Project






42. Must have a one-to-one relationship with all other forms.






43. You can _____________ in the Architect Graphical Interface.






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






45. OLAP data storage measure






46. Used for - Initially populating the Metadata - Creating schema objects






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






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






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






50. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse