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. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.






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






3. All report-level options overwrite ___________.






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






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






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






7. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






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






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






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






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






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






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






14. You can _____________ in the Architect Graphical Interface.






15. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save






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






17. ID columns - Description columns - Fact columns






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






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






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






21. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






22. OLAP data storage measure






23. A feature that enables users to delivers reports to the history list - cache or mobile






24. View Filters are saved with the _____________.






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






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






27. Creating multiple attributes quickly. Used during the initial project creation.






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






29. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






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






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






32. Attribute Creation Wizard - Attribute Editor






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


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






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






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






37. OLAP retains data ________






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






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






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






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






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






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






44. Enables you to select which tables from the data-warehouse to store in the Metadata database






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






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






47. Subtotals reflect accumulations at selected attribute levels






48. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






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






50. User requirements - Existing source data - Technical and performance considerations