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 on relationships between 2 or more tables (attributes) - like an Index table.






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






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






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






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






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. The actual column name for a fact. Every fact must have at least 1 expression.






8. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






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






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






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






12. A shortcut to an existing Object in a Project






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






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






15. Enables you to search for a specific Object or group of Objects that meet a certain criteria.






16. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






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






18. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.






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






20. OLTP data storage measure






21. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






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






23. Reduced number of JOINS in the generated SQL






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






25. Schema Objects - Application Objects - Configuration Objects






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






27. Create the Project Source - Create the Database Instance






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






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






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






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






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






33. Subtotals reflect accumulations at selected attribute levels






34. More storage - Complex SQL - Simple ETL






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






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






37. You can e-mail reports by going to _____






38. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






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






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






41. A user interface for creating and maintaining a BI environment






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






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






44. Descriptive data that provides context for Facts.






45. ID columns - Description columns - Fact columns






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






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






48. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.






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






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