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 associated to different column names in 2 or more tables






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






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






4. OLTP data storage measure






5. Primary keys






6. Less storage - Simple SQL - Complex ETL






7. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






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






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






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






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






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






13. Direct: 2-tier - Server: 3-tier






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






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






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






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






18. You can _____________ in the Architect Graphical Interface.






19. Folder List - Object Viewer - Shortcut Bar






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






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






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






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






24. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.






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






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






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






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


29. Descriptive data that provides context for Facts.






30. Schema Objects - Application Objects - Configuration Objects






31. Using the Prompt Generation Wizard - Inside the Report Editor






32. AND - OR - OR NOT - AND NOT






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






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






35. All Attributes must have an _______.






36. The default entry-points.






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






38. Template - Filter - View of a Report






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






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






41. It contains the ID column of the parent attribute






42. It contains the ID column of all higher-level attributes






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






44. Create the Project Source - Create the Database Instance






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






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






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






48. OLTP retains data ________






49. To define the level of aggregation for a specific metric - Used for qualifications






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