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. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






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






4. What tool do you use to create the Metadata shell?






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






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






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






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






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






10. Used to modify a Report






11. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






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


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






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






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






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






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






18. The Attribute Form maps to the same column name in multiple tables






19. ID columns - Description columns - Fact columns






20. Attribute Creation Wizard - Attribute Editor






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






22. It contains the ID column of the parent attribute






23. Homogeneous - Heterogeneous






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






25. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






26. Primary keys






27. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






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






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






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






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






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






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






34. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save






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






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






37. All report-level options overwrite ___________.






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






39. Schema Objects - Application Objects - Configuration Objects






40. One that uses 2 or more columns as its ID






41. View Filters can only ___________.






42. What tool do you use to create the Metadata DSN connection?






43. All Attributes must have an _______.






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






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






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






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






48. View Filters are saved with the _____________.






49. Reduced number of JOINS in the generated SQL






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