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. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)






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






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






4. OLAP data storage measure






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






6. How users can share comments for reports to other users






7. All report-level options overwrite ___________.






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






9. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.






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






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






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






13. Used to create or edit complex attributes - facts - hierarchies - and logical tables






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






15. Homogeneous - Heterogeneous






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






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






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






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






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






21. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema






22. It contains the ID column of the parent attribute






23. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded






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






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






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






27. Level of OLTP integration






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






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






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






31. ID columns - Description columns - Fact columns






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






33. Allow you to interact with the BI system - logically organize data to analyze complex relationships






34. A condition data must meet in order to be included in a report. Does affect the SQL.






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






36. The actual column name for a fact. Every fact must have at least 1 expression.






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






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






39. All Attributes must have an _______.






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






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






42. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships






43. Descriptive data that provides context for Facts.






44. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






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






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






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






48. Template - Filter - View of a Report






49. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






50. A shortcut to an existing Object in a Project