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. All Attributes must have an _______.






2. OLAP retains data ________






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






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






5. All report-level options overwrite ___________.






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






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






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






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






10. ID columns - Description columns - Fact columns






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






12. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications






13. A condition data must meet in order to be included in a report. Does affect the SQL.






14. Used to "fine-tune" your Project






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






16. Simple - Derived






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






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






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


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






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






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






23. OLTP data storage measure






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






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






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






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






28. Facts - Attributes - Hierarchies






29. Homogeneous - Heterogeneous






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






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






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






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






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






35. Schema Objects - Application Objects - Configuration Objects






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






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






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






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






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






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






42. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling






43. Compound - Homogeneous - Heterogeneous






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






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






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






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






48. Enables you to rearrange the columns and rows in a report.






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






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