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. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






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






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






4. How users can share comments for reports to other users






5. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse






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






7. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






8. Store info on relationships between 2 or more tables (attributes) - like an Index table.






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






10. You can _____________ in the Architect Graphical Interface.






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






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






13. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






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






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






16. All Attributes must have an _______.






17. A feature that enables users to delivers reports to the history list - cache or mobile






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






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






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






21. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition






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






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






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






25. Facts - Attributes - Hierarchies






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






27. Metrics that perform multiple aggregations; one calculation inside of another.






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






29. Schema Objects - Application Objects - Configuration Objects






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






31. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save






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






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






34. Descriptive data that provides context for Facts.






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






36. OLAP data storage measure






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






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






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






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






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






42. User requirements - Existing source data - Technical and performance considerations






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






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






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






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






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






48. OLTP data storage measure






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






50. Attribute Creation Wizard - Attribute Editor