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. Groupings of directly related attributes. Also commonly known as "dimensions".






2. Level of OLTP integration






3. View Filters can only ___________.






4. Attribute Creation Wizard - Attribute Editor






5. OLAP retains data ________






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






7. OLTP retains data ________






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






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. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






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






12. Columns - Tables






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






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






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






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






17. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






18. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






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






20. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






21. Facts - Attributes - Hierarchies






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






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






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






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






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






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






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






29. Less storage - Simple SQL - Complex ETL






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






31. All Attributes must have an _______.






32. Used to "fine-tune" your Project






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






34. Template - Filter - View of a Report






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






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






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






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






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






40. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






41. Subtotals reflect accumulations at selected attribute levels






42. To define the level of aggregation for a specific metric - Used for qualifications






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






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






45. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.






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


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






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






49. Create the Project Source - Create the Database Instance






50. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.