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. OLTP retains data ________






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






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






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






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






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






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






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






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






10. Level of OLTP integration






11. Homogeneous - Heterogeneous






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






13. All Attributes must have an _______.






14. Level of OLAP integration






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






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






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






18. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






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






20. Attribute Creation Wizard - Attribute Editor






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






22. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling






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






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






25. Columns - Tables






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






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






28. OLTP data storage measure






29. Descriptive data that provides context for Facts.






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






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. The System Hierarchy is automatically updated whenever you make a change to an __________________.






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






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






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






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






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






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






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






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






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






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






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






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






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






46. Prompts to select a single value on which to qualify a date - number or text string.






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






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






49. A shortcut to an existing Object in a Project






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