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. OLTP data storage measure






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






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






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






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






6. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






7. OLAP data storage measure






8. AND - OR - OR NOT - AND NOT






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






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






11. Less storage - Simple SQL - Complex ETL






12. Top menu/dropdowns - Toolbar - Right-click popup menus






13. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.






14. Columns - Tables






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






16. A subset of a report that users can manipulate without altering the SQL

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


17. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






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






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






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






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






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






23. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.






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






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






26. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






27. A shortcut to an existing Object in a Project






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






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






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






31. Primary keys






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






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






34. Descriptive data that provides context for Facts.






35. Specifies a condition data must meet in order to be included in a report






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






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






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






39. Create the Project Source - Create the Database Instance






40. The Attribute Form Expression that maps to a single column - no matter the number of tables






41. All report-level options overwrite ___________.






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






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






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






45. Compound - Homogeneous - Heterogeneous






46. Used to modify a Report






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






48. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






49. Enables you to search for a specific Object or group of Objects that meet a certain criteria.






50. Simple - Derived