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. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






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






4. Simple - Derived






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






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






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






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






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






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






11. You can _____________ in the Architect Graphical Interface.






12. Extraction - transformation - loading






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






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






15. Reduced number of JOINS in the generated SQL






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






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






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






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






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






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

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


22. Used to "fine-tune" your Project






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






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






25. AND - OR - OR NOT - AND NOT






26. All report-level options overwrite ___________.






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






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






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






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






31. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






32. All Attributes must have an _______.






33. Specifies a condition data must meet in order to be included in a report






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






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






36. Facts - Attributes - Hierarchies






37. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






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






39. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded






40. Descriptive data that provides context for Facts.






41. Specifies what info to retrieve from a data-warehouse - and how to display it






42. Facts associated to the same column name in 1 or more tables






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






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. The Attribute Form maps to the same column name in multiple tables






46. Level of OLAP integration






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






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






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






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