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. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






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






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






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






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






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






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






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






9. An environment in which the MSTR Desktop connects directly to the Metadata database.






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






11. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse






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






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






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






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






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






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






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






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






20. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications






21. Store info on relationships between 2 or more tables (attributes) - like an Index table.






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






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






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






25. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






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






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






28. Level of OLAP integration






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






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






31. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)






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






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






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






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






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






37. Template - Filter - View of a Report






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






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






40. What tool do you use to create the Metadata DSN connection?






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






42. Schema Objects - Application Objects - Configuration Objects






43. Extraction - transformation - loading






44. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






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






46. Grid View - Graph View - Grid/Graph View - SQL View






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






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






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






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