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. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.






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






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






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






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






6. Level of OLTP integration






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






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






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






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






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






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






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






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






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. An environment in which the MSTR Desktop connects directly to the Metadata database.






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






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






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






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






22. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling






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






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






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






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






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






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






29. The Attribute Form maps to different column names in multiple tables






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






31. Simple - Derived






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






33. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






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






35. Schema Objects - Application Objects - Configuration Objects






36. It contains the ID and DESC columns of all higher-level attributes






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






38. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






39. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






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






41. Reduced number of JOINS in the generated SQL






42. Create the Project Source - Create the Database Instance






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






44. AND - OR - OR NOT - AND NOT






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






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






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






48. OLTP data storage measure






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






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