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. Facts - Attributes - Hierarchies






2. Homogeneous - Heterogeneous






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






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






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






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






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






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






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






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






11. Attribute Creation Wizard - Attribute Editor






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






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






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






15. What tool do you use to create the Metadata shell?






16. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






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






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






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






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






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






22. Subtotals reflect accumulations at selected attribute levels






23. Used to modify a Report






24. Columns - Tables






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






26. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






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






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






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






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






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






32. OLTP data storage measure






33. View Filters are saved with the _____________.






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






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






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






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






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






39. OLAP data storage measure






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






41. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






42. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






43. Tables - Facts - Attributes - Hierarchies






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






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






46. Specifies what info to retrieve from a data-warehouse - and how to display it






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






48. The default entry-points.






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






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