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. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






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






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






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






5. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






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






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






8. View Filters are saved with the _____________.






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






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






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






12. Filter definition prompts - Object prompts - Value prompts - Level prompts






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






14. You can _____________ in the Architect Graphical Interface.






15. ID columns - Description columns - Fact columns






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






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






18. Primary keys






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






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






21. OLTP data storage measure






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






23. More storage - Complex SQL - Simple ETL






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






25. What tool do you use to create the Metadata shell?






26. Level of OLTP integration






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






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






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






30. Less storage - Simple SQL - Complex ETL






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






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






33. Create the Project Source - Create the Database Instance






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






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






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






37. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






38. Used to "fine-tune" your Project






39. The default entry-points.






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






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






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






43. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.






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






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






46. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






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






48. Specifies a condition data must meet in order to be included in a report






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






50. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports