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. OLAP data storage measure






2. Columns - Tables






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






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






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






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






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






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






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






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






11. Extraction - transformation - loading






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






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






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






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






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






17. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.






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






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






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






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






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






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






24. Template - Filter - View of a Report






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






26. Store info on relationships between 2 or more tables (attributes) - like an Index table.






27. Facts - Attributes - Hierarchies






28. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






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






30. Prompts to select a single value on which to qualify a date - number or text string.






31. Grid View - Graph View - Grid/Graph View - SQL View






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






33. It contains the ID column of the parent attribute






34. Reduced number of JOINS in the generated SQL






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






36. Simple - Derived






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






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






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






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






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






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






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






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






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






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






47. AND - OR - OR NOT - AND NOT






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






49. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling






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