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. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






2. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling






3. More storage - Complex SQL - Simple ETL






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






5. Homogeneous - Heterogeneous






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






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






8. Groupings of directly related attributes. Also commonly known as "dimensions".






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






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






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






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






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






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






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






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






17. It contains the ID column of the parent attribute






18. Compound - Homogeneous - Heterogeneous






19. OLAP data storage measure






20. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






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. Grid View - Graph View - Grid/Graph View - SQL View






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






24. Simple - Compound - Nested - Derived






25. Descriptive data that provides context for Facts.






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






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






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






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






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






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






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






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






34. Reduced number of JOINS in the generated SQL






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






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






37. AND - OR - OR NOT - AND NOT






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






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. How users can share comments for reports to other users






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






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






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






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






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






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






47. Folder List - Object Viewer - Shortcut Bar






48. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






49. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






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