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. Enables you to select which tables from the data-warehouse to store in the Metadata database






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






3. Tables - Facts - Attributes - Hierarchies






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






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






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






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






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






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






10. Facts - Attributes - Hierarchies






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






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


13. Reduced number of JOINS in the generated SQL






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






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






16. Extraction - transformation - loading






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






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






19. OLAP retains data ________






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






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






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






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






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






25. Simple - Derived






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






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






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






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






30. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






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






32. More storage - Complex SQL - Simple ETL






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






34. Grid View - Graph View - Grid/Graph View - SQL View






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






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






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






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






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






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






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






42. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






43. One that uses 2 or more columns as its ID






44. Used to limit a possibly overwhelming set of potential prompt answers






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






46. Used to modify a Report






47. Template - Filter - View of a Report






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






49. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






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