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. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






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






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






4. A shortcut to an existing Object in a Project






5. Reduced number of JOINS in the generated SQL






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






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






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






9. AND - OR - OR NOT - AND NOT






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






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






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






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






14. OLTP data storage measure






15. Descriptive data that provides context for Facts.






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






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






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






19. Columns - Tables






20. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling






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






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






23. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






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






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






27. Used for - Initially populating the Metadata - Creating schema objects






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






29. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents






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






31. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






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






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






34. A development environment to create BI applications - allowing users to edit the Metadata database






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






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






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






38. ID columns - Description columns - Fact columns






39. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






40. Simple - Compound - Nested - Derived






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






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






43. Must have Subtotals enabled - or you won't see any data for higher-level attributes






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






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






46. Facts - Attributes - Hierarchies






47. You can _____________ in the Architect Graphical Interface.






48. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






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






50. Used to modify a Report