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. A condition data must meet in order to be included in a report. Does affect the SQL.






2. Level of OLAP integration






3. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






4. What tool do you use to create the Metadata DSN connection?






5. Simple - Compound - Nested - Derived






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






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






8. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.






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






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






11. Compound - Homogeneous - Heterogeneous






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






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






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






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






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






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






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






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






20. Used to limit a possibly overwhelming set of potential prompt answers






21. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






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






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






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






25. Level of OLTP integration






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






27. One that uses 2 or more columns as its ID






28. Reduced number of JOINS in the generated SQL






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






30. View Filters are saved with the _____________.






31. ID columns - Description columns - Fact columns






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






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






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






35. Primary keys






36. Columns - Tables






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






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






39. Simple - Derived






40. OLAP retains data ________






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






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






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






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






45. Filter definition prompts - Object prompts - Value prompts - Level prompts






46. Folder List - Object Viewer - Shortcut Bar






47. Used to "fine-tune" your Project






48. Less storage - Simple SQL - Complex ETL






49. Facts - Attributes - Hierarchies






50. A shortcut to an existing Object in a Project