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. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






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






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






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






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






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






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






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






9. A condition data must meet in order to be included in a report. Does affect the SQL.






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






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






12. View Filters can only ___________.






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






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






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






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






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






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






19. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.






20. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships






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






22. You can _____________ in the Architect Graphical Interface.






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






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






25. Homogeneous - Heterogeneous






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






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






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






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






30. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen






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






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






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






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






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






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






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






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






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






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






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






42. Tables - Facts - Attributes - Hierarchies






43. It contains the ID column of the parent attribute






44. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






45. Must have a one-to-one relationship with all other forms.






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






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






48. Used to modify a Report






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






50. Used for - Initially populating the Metadata - Creating schema objects