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. OLAP Services does not add any ______ to the report query.






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






3. ID columns - Description columns - Fact columns






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






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






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






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






8. Formula - Level (Dimensionality) - Conditionality - Transformation






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






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






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






12. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema






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






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






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






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






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






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






19. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.






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






21. Template - Filter - View of a Report






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






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






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






25. Descriptive data that provides context for Facts.






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






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






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






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






30. Facts associated to different column names in 2 or more tables






31. More storage - Complex SQL - Simple ETL






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






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






34. OLTP retains data ________






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






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






37. Level of OLAP integration






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






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






40. Homogeneous - Heterogeneous






41. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






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


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






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






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






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






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






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






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






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