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. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






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






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






4. The default entry-points.






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






6. Level of OLAP integration






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






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






9. Subtotals reflect accumulations at selected attribute levels






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






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






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






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






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






15. The System Hierarchy is automatically updated whenever you make a change to an __________________.






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






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






18. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






19. Used for - Initially populating the Metadata - Creating schema objects






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






21. Enables you to lock column headers so that they always appear when scrolling






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






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






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






25. You can _____________ in the Architect Graphical Interface.






26. You must select "Other directions" when drilling attributes while viewing a report






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






28. Template - Filter - View of a Report






29. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






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






31. Tables - Facts - Attributes - Hierarchies






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






33. The Attribute Form Expression that maps to a single column - no matter the number of tables






34. A user interface for creating and maintaining a BI environment






35. All report-level options overwrite ___________.






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






37. Columns - Tables






38. Descriptive data that provides context for Facts.






39. Homogeneous - Heterogeneous






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






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






42. The Attribute Form maps to the same column name in multiple tables






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






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






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






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






47. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.






48. Schema Objects - Application Objects - Configuration Objects






49. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






50. All Attributes must have an _______.