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. OLAP Services does not add any ______ to the report query.






2. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.






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






4. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen






5. Schema Objects - Application Objects - Configuration Objects






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






7. Create the Project Source - Create the Database Instance






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






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






10. You can e-mail reports by going to _____






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






12. Used to modify a Report






13. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






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






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






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






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






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






19. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.






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






21. Tables - Facts - Attributes - Hierarchies






22. It contains the ID and DESC columns of all higher-level attributes






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






24. Columns - Tables






25. Top menu/dropdowns - Toolbar - Right-click popup menus






26. Metrics aggregate on the lowest-level attribute __________.






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






28. Reduced number of JOINS in the generated SQL






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






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






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






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






33. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






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






35. Level of OLTP integration






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






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


38. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






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






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






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






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






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






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






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






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






47. A shortcut to an existing Object in a Project






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






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






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