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. Facts - Attributes - Hierarchies






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






3. The logical associations between attributes that exist based on a business rule






4. AND - OR - OR NOT - AND NOT






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






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






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






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






9. Template - Filter - View of a Report






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






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






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






13. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition






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






15. OLAP data storage measure






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






17. View Filters can only ___________.






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






19. View Filters are saved with the _____________.






20. More storage - Complex SQL - Simple ETL






21. All Attributes must have an _______.






22. OLTP retains data ________






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






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






25. Schema Objects - Application Objects - Configuration Objects






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






27. Primary keys






28. OLAP retains data ________






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






30. Compound - Homogeneous - Heterogeneous






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






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






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






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






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






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






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






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






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






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






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






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






43. Descriptive data that provides context for Facts.






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


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






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






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






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






49. Create the Project Source - Create the Database Instance






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