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 you to rearrange the columns and rows in a report.






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






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






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






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






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






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






8. Tables - Facts - Attributes - Hierarchies






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






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






11. Reduced number of JOINS in the generated SQL






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






13. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






14. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






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






16. Facts - Attributes - Hierarchies






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






18. Specifies a condition data must meet in order to be included in a report






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






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






21. Simple - Derived






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






23. Enables you to lock column headers so that they always appear when scrolling






24. OLAP data storage measure






25. To see data at completely different levels - other than that of the original Grid or Graph






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






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






28. Used to modify a Report






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






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






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






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






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






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






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






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






37. Subtotals reflect accumulations at selected attribute levels






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






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






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






41. Descriptive data that provides context for Facts.






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






43. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound






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






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






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






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






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






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






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