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. An environment in which the MSTR Desktop connects directly to the Metadata database.






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






3. Enables you to lock column headers so that they always appear when scrolling






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






5. Level of OLAP integration






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






7. Primary keys






8. Subtotals reflect accumulations at selected attribute levels






9. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






10. Facts - Attributes - Hierarchies






11. All Attributes must have an _______.






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






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






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






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






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






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






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






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






20. OLTP data storage measure






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






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






23. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).






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






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






26. Used to "fine-tune" your Project






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






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






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






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






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






32. Used to modify a Report






33. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






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






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






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






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






38. Less storage - Simple SQL - Complex ETL






39. The unique values of an attribute obtained from the data-warehouse






40. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






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






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






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






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






46. Columns - Tables






47. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.






48. AND - OR - OR NOT - AND NOT






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






50. OLTP retains data ________