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. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






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






3. OLAP Services does not add any ______ to the report query.






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






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






6. Used to "fine-tune" your Project






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






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






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






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






11. User requirements - Existing source data - Technical and performance considerations






12. Attribute Creation Wizard - Attribute Editor






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






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






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






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






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






18. Primary keys






19. Store info on relationships between 2 or more tables (attributes) - like an Index table.






20. Template - Filter - View of a Report






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






22. Must have a one-to-one relationship with all other forms.






23. All report-level options overwrite ___________.






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






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






26. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






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






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






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


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






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






32. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






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






34. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts






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






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






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






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






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






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






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






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






43. To define the level of aggregation for a specific metric - Used for qualifications






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






45. AND - OR - OR NOT - AND NOT






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






47. A shortcut to an existing Object in a Project






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






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






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