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. Allow you to interact with the BI system - logically organize data to analyze complex relationships






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






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






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






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






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






7. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






8. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






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






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






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






12. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.






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






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






15. Simple - Derived






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






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






18. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






19. Folder List - Object Viewer - Shortcut Bar






20. Level of OLAP integration






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






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






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






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






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






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






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






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






29. Attribute Creation Wizard - Attribute Editor






30. Used to "fine-tune" your Project






31. All report-level options overwrite ___________.






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






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






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






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






36. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






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






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






39. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound






40. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






41. Create the Project Source - Create the Database Instance






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






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






44. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






45. OLAP retains data ________






46. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.






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






48. Enables you to select and display subsets of a report as separate pages.






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






50. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema