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. Descriptive data that provides context for Facts.






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






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






4. Grid View - Graph View - Grid/Graph View - SQL View






5. Less storage - Simple SQL - Complex ETL






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






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






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






9. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner






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






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






12. Used to modify a Report






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






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






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






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






17. Enables you to lock column headers so that they always appear when scrolling






18. The default entry-points.






19. A shortcut to an existing Object in a Project






20. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






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






22. A subset of a report that users can manipulate without altering the SQL


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






24. A feature that enables users to delivers reports to the history list - cache or mobile






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






26. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier






27. Tables - Facts - Attributes - Hierarchies






28. Extraction - transformation - loading






29. OLTP data storage measure






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






31. It contains links to specific folders in the Folder List






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






33. Contains info that facilitates the transfer of data from the source systems to the data-warehouse






34. Reduced number of JOINS in the generated SQL






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






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






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






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






39. You can _____________ in the Architect Graphical Interface.






40. Facts - Attributes - Hierarchies






41. Primary keys






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






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






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






45. View Filters are saved with the _____________.






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






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






48. Direct: 2-tier - Server: 3-tier






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






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