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. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts






2. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






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






4. Less storage - Simple SQL - Complex ETL






5. Simple - Derived






6. Tables - Facts - Attributes - Hierarchies






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






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






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






10. Extraction - transformation - loading






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






12. OLAP retains data ________






13. A condition data must meet in order to be included in a report. Does affect the SQL.






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






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






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






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






18. AND - OR - OR NOT - AND NOT






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






20. All Attributes must have an _______.






21. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save






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






23. Reduced number of JOINS in the generated SQL






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

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


25. The Attribute Form Expression that maps to a single column - no matter the number of tables






26. Create the Project Source - Create the Database Instance






27. Level of OLAP integration






28. More storage - Complex SQL - Simple ETL






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






30. OLTP data storage measure






31. Folder List - Object Viewer - Shortcut Bar






32. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema






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






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






35. Subtotals reflect accumulations at selected attribute levels






36. Homogeneous - Heterogeneous






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






38. Template - Filter - View of a Report






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






40. How users can share comments for reports to other users






41. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






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






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






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






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






46. The unique values of an attribute obtained from the data-warehouse






47. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






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






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






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