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. A condition data must meet in order to be included in a report. Does affect the SQL.






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






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






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






5. Schema Objects - Application Objects - Configuration Objects






6. A subset of a report that users can manipulate without altering the SQL


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






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






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






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






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






12. Folder List - Object Viewer - Shortcut Bar






13. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






14. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






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






17. Columns - Tables






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






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






20. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy






21. A Project Source can house ________ . A single Metadata can be used by multiple Projects.






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






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






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






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






26. Attribute Creation Wizard - Attribute Editor






27. What tool do you use to create the Metadata DSN connection?






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






29. Extraction - transformation - loading






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






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






32. OLAP retains data ________






33. ID columns - Description columns - Fact columns






34. Level of OLTP integration






35. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






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






37. An environment in which the MSTR Desktop connects directly to the Metadata database.






38. Filter definition prompts - Object prompts - Value prompts - Level prompts






39. OLTP retains data ________






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






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






42. It contains the ID and DESC columns of all higher-level attributes






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






44. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






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






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






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






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






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






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