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. A development environment to create BI applications - allowing users to edit the Metadata database






2. Reduced number of JOINS in the generated SQL






3. The Attribute Form maps to different column names in multiple tables






4. AND - OR - OR NOT - AND NOT






5. Simple - Derived






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






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






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






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






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






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






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






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






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






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






16. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






17. All report-level options overwrite ___________.






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






19. Enables you to select and display subsets of a report as separate pages.






20. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






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






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






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






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






25. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).






26. A shortcut to an existing Object in a Project






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






28. OLTP data storage measure






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






30. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






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






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






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






34. Descriptive data that provides context for Facts.






35. Enables you to rearrange the columns and rows in a report.






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






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






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






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






40. OLTP retains data ________






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






42. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






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






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






45. Create the Project Source - Create the Database Instance






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






47. A method of organizing the appearance of report results in a Grid report based on a criteria






48. Extraction - transformation - loading






49. Metrics aggregate on the lowest-level attribute __________.






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