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 you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.






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






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






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






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






6. Level of OLAP integration






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






8. Homogeneous - Heterogeneous






9. Template - Filter - View of a Report






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






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






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






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






14. You can _____________ in the Architect Graphical Interface.






15. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






17. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






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






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






20. AND - OR - OR NOT - AND NOT






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






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






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






24. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






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






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






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






28. OLTP data storage measure






29. It contains the ID column of the parent attribute






30. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner






31. Tables - Facts - Attributes - Hierarchies






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






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






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






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






36. The default entry-points.






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






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






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






40. ID columns - Description columns - Fact columns






41. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






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






43. It contains the ID and DESC columns of all higher-level attributes






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. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded






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






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






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






49. Reduced number of JOINS in the generated SQL






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