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. Subtotals reflect accumulations at selected attribute levels






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






3. Enables you to select and display subsets of a report as separate pages.






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






5. You can e-mail reports by going to _____






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






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






8. Metrics aggregate on the lowest-level attribute __________.






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






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






11. ID columns - Description columns - Fact columns






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






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






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






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






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






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






18. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






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






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






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






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






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






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






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






26. All Attributes must have an _______.






27. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






28. OLAP retains data ________






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






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






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






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






33. Level of OLTP integration






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






35. View Filters are saved with the _____________.






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






37. OLTP retains data ________






38. Primary keys






39. Descriptive data that provides context for Facts.






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






41. Grid View - Graph View - Grid/Graph View - SQL View






42. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






43. Extraction - transformation - loading






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






45. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






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






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






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






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






50. Less storage - Simple SQL - Complex ETL