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. Folder List - Object Viewer - Shortcut Bar






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






3. Less storage - Simple SQL - Complex ETL






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






5. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






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






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






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






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


10. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts






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






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






13. Compound - Homogeneous - Heterogeneous






14. Create the Project Source - Create the Database Instance






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






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






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






18. Level of OLTP integration






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






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






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






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






23. It contains the ID column of the parent attribute






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






25. Descriptive data that provides context for Facts.






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






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






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






29. A feature that enables users to delivers reports to the history list - cache or mobile






30. Columns - Tables






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






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






33. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






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






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






36. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






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






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






39. A method of organizing the appearance of report results in a Grid report based on a criteria






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






41. Used to modify a Report






42. Enables you to lock column headers so that they always appear when scrolling






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






44. Facts - Attributes - Hierarchies






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






46. ID columns - Description columns - Fact columns






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






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






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






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