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. Direct: 2-tier - Server: 3-tier






2. Subtotals reflect accumulations at selected attribute levels






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






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






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






6. A subset of a report that users can manipulate without altering the SQL

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


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






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






9. It contains the ID and DESC columns of all higher-level attributes






10. A Project Source can house ________ . A single Metadata can be used by multiple Projects.






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






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






13. It contains the ID column of all higher-level attributes






14. Reduced number of JOINS in the generated SQL






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






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






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






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






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






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






21. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






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






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






24. More storage - Complex SQL - Simple ETL






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






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






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






28. Tables - Facts - Attributes - Hierarchies






29. The unique values of an attribute obtained from the data-warehouse






30. A new tool for project design tasks - used for fine-tuning a project after initial creation






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






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






33. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






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






35. Compound - Homogeneous - Heterogeneous






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






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






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






39. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters






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






41. Level of OLAP integration






42. All report-level options overwrite ___________.






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






44. Extraction - transformation - loading






45. Columns - Tables






46. Used to create or edit complex attributes - facts - hierarchies - and logical tables






47. Primary keys






48. OLTP data storage measure






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






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