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. How users can share comments for reports to other users






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


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






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






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






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






7. More storage - Complex SQL - Simple ETL






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






9. Enables you to format report values based on a condition - such as highlights - font colors - etc.






10. Columns - Tables






11. Formula - Level (Dimensionality) - Conditionality - Transformation






12. Less storage - Simple SQL - Complex ETL






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






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






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






16. Used to modify a Report






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






18. Groupings of directly related attributes. Also commonly known as "dimensions".






19. The default entry-points.






20. Tables - Facts - Attributes - Hierarchies






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






22. A shortcut to an existing Object in a Project






23. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format






24. Subtotals reflect accumulations at selected attribute levels






25. The logical associations between attributes that exist based on a business rule






26. Level of OLAP integration






27. Enables you to select which tables from the data-warehouse to store in the Metadata database






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






29. ID columns - Description columns - Fact columns






30. OLAP retains data ________






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






32. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.






33. View Filters can only ___________.






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






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






36. Used to create or edit complex attributes - facts - hierarchies - and logical tables






37. OLTP retains data ________






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






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






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






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






42. Simple - Compound - Nested - Derived






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






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






45. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






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






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






48. A user interface for creating and maintaining a BI environment






49. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






50. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities