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. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.






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






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






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






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






6. Primary keys






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






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






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






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






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






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






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






14. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






15. Level of OLAP integration






16. Compound - Homogeneous - Heterogeneous






17. Facts - Attributes - Hierarchies






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






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






20. Level of OLTP integration






21. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.






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






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






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






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






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






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






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






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






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






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






32. User reporting requirements - Query performance - Data volume - DB Maintenance






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






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






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






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






37. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






38. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






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






40. Descriptive data that provides context for Facts.






41. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






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






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






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






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


46. The actual column name for a fact. Every fact must have at least 1 expression.






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






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






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






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