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


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






3. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.






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






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






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






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






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






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






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






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






12. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






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






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






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






16. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound






17. Columns - Tables






18. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities






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






20. OLTP data storage measure






21. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






22. Metrics aggregate on the lowest-level attribute __________.






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






24. You can _____________ in the Architect Graphical Interface.






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






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






27. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






28. Extraction - transformation - loading






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






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






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






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






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






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






35. Enables you to select and display subsets of a report as separate pages.






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






37. OLTP retains data ________






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






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






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






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






42. Contains info that facilitates the transfer of data from the source systems to the data-warehouse






43. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






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






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






46. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






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






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






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






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