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 detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






2. Creating multiple attributes quickly. Used during the initial project creation.






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






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






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






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






7. Primary keys






8. View Filters are saved with the _____________.






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






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






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






12. A shortcut to an existing Object in a Project






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






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






15. Subtotals reflect accumulations at selected attribute levels






16. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse






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






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






19. Extraction - transformation - loading






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






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






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






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






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






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






26. The default entry-points.






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






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






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






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






31. You can _____________ in the Architect Graphical Interface.






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


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






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






35. Descriptive data that provides context for Facts.






36. OLAP retains data ________






37. Level of OLAP integration






38. Tables - Facts - Attributes - Hierarchies






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






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






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






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






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






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






45. All report-level options overwrite ___________.






46. OLTP data storage measure






47. Grid View - Graph View - Grid/Graph View - SQL View






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






49. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.






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







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:



Major Subjects



Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Most popular tests