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. Level of OLAP integration






2. Reduced number of JOINS in the generated SQL






3. View Filters are saved with the _____________.






4. OLTP retains data ________






5. Subtotals reflect accumulations at selected attribute levels






6. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.






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






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






9. Used for - Initially populating the Metadata - Creating schema objects






10. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






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






12. All report-level options overwrite ___________.






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






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. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






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






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






18. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound






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






20. OLTP data storage measure






21. Enables you to select and display subsets of a report as separate pages.






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






23. More storage - Complex SQL - Simple ETL






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






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






26. Simple - Compound - Nested - Derived






27. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






28. Homogeneous - Heterogeneous






29. Extraction - transformation - loading






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






31. ID columns - Description columns - Fact columns






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






33. Columns - Tables






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






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






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






37. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






38. Folder List - Object Viewer - Shortcut Bar






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






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






41. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.






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


43. Level of OLTP integration






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






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






46. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.






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






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






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






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