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. Must have Subtotals enabled - or you won't see any data for higher-level attributes






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






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






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






5. The unique values of an attribute obtained from the data-warehouse






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






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






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






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






10. More storage - Complex SQL - Simple ETL






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






12. Facts - Attributes - Hierarchies






13. To see data at completely different levels - other than that of the original Grid or Graph






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






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






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






17. Subtotals reflect accumulations at selected attribute levels






18. Columns - Tables






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






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






21. OLTP data storage measure






22. Primary keys






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






24. A new tool for project design tasks - used for fine-tuning a project after initial creation






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






26. Simple - Compound - Nested - Derived






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






28. Template - Filter - View of a Report






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






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






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






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






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






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






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






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






37. The default entry-points.






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






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






40. Extraction - transformation - loading






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






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






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






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






45. Allow you to interact with the BI system - logically organize data to analyze complex relationships






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






47. Level of OLTP integration






48. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.






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






50. Less storage - Simple SQL - Complex ETL