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. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






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






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






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. Facts associated to different column names in 2 or more tables






6. The default entry-points.






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






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






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






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






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






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






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






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






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






16. OLAP data storage measure






17. Reduced number of JOINS in the generated SQL






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


19. Tables - Facts - Attributes - Hierarchies






20. OLAP Services does not add any ______ to the report query.






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






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






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






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






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






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






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






28. The System Hierarchy is automatically updated whenever you make a change to an __________________.






29. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






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






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






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






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






34. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)






35. User requirements - Existing source data - Technical and performance considerations






36. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling






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






38. A shortcut to an existing Object in a Project






39. Using the Prompt Generation Wizard - Inside the Report Editor






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






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






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






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






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






45. Subtotals reflect accumulations at selected attribute levels






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






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






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






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






50. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.