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. Enables you to format report values based on a condition - such as highlights - font colors - etc.






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






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






4. Template - Filter - View of a Report






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






6. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.






7. OLAP Services does not add any ______ to the report query.






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






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






10. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






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






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






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






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






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






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






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






18. Metrics that perform multiple aggregations; one calculation inside of another.






19. Level of OLTP integration






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






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






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






23. Must have Subtotals enabled - or you won't see any data for higher-level attributes






24. The default entry-points.






25. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked






26. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.






27. Level of OLAP integration






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






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






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






31. Attribute Creation Wizard - Attribute Editor






32. Must have a one-to-one relationship with all other forms.






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






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






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






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






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






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






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






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






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






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






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






44. Simple - Compound - Nested - Derived






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






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






47. It contains the ID column of all higher-level attributes






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






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






50. To define the level of aggregation for a specific metric - Used for qualifications