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. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






2. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






3. Homogeneous - Heterogeneous






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






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






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






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






8. OLAP data storage measure






9. Used to modify a Report






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






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






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






13. AND - OR - OR NOT - AND NOT






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






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






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






17. User requirements - Existing source data - Technical and performance considerations






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






19. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)






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






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






22. Formula - Level (Dimensionality) - Conditionality - Transformation






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






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






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






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






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






28. Using the Prompt Generation Wizard - Inside the Report Editor






29. ID columns - Description columns - Fact columns






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






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






32. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts






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






34. Template - Filter - View of a Report






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






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






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






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






39. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






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






41. Schema Objects - Application Objects - Configuration Objects






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






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






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






45. Less storage - Simple SQL - Complex ETL






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






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. Attribute Creation Wizard - Attribute Editor






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






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