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. Less storage - Simple SQL - Complex ETL






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






3. Reduced number of JOINS in the generated SQL






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






5. Attribute Creation Wizard - Attribute Editor






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






7. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






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






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






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






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






12. Grid View - Graph View - Grid/Graph View - SQL View






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






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






15. It contains the ID column of the parent attribute






16. OLAP retains data ________






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






18. User requirements - Existing source data - Technical and performance considerations






19. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






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






21. The default entry-points.






22. OLAP data storage measure






23. Contains info that facilitates the transfer of data from the source systems to the data-warehouse






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






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






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






27. Extraction - transformation - loading






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






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






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






31. Homogeneous - Heterogeneous






32. User reporting requirements - Query performance - Data volume - DB Maintenance






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






34. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






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






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






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






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






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






40. Descriptive data that provides context for Facts.






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






42. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






43. A method of organizing the appearance of report results in a Grid report based on a criteria






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






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






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






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






48. Used to modify a Report






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






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