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. Used to modify a Report






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






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






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






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






6. You can _____________ in the Architect Graphical Interface.






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


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






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






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






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






12. View Filters are saved with the _____________.






13. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






14. Tables - Facts - Attributes - Hierarchies






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






16. Used to "fine-tune" your Project






17. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier






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






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






20. Extraction - transformation - loading






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






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






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






24. The Attribute Form maps to the same column name in multiple tables






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






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






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






28. Attribute Creation Wizard - Attribute Editor






29. Facts associated to the same column name in 1 or more tables






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






31. The default entry-points.






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






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






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






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






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






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






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






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






40. Less storage - Simple SQL - Complex ETL






41. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen






42. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner






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






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






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






46. Simple - Compound - Nested - Derived






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






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






49. View Filters can only ___________.






50. Facts - Attributes - Hierarchies