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 retains data ________






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






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






4. The Attribute Form Expression that maps to a single column - no matter the number of tables






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






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






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






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






9. View Filters are saved with the _____________.






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


11. A shortcut to an existing Object in a Project






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






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






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






15. A Project Source can house ________ . A single Metadata can be used by multiple Projects.






16. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






17. Used to "fine-tune" your Project






18. View Filters can only ___________.






19. All Attributes must have an _______.






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






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






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






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






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






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






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






27. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






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






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






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






31. ID columns - Description columns - Fact columns






32. The default entry-points.






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






34. Reduced number of JOINS in the generated SQL






35. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier






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






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






38. Extraction - transformation - loading






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






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






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






42. Used to create or edit complex attributes - facts - hierarchies - and logical tables






43. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse






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






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






46. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






47. To see data at completely different levels - other than that of the original Grid or Graph






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






49. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






50. Tables - Facts - Attributes - Hierarchies