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. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






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






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






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






5. Enables you to select which tables from the data-warehouse to store in the Metadata database






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






7. ID columns - Description columns - Fact columns






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






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






10. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)






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






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






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






14. Grid View - Graph View - Grid/Graph View - SQL View






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






16. Enables you to rearrange the columns and rows in a report.






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






18. The Attribute Form Expression that maps to a single column - no matter the number of tables






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






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






21. You can _____________ in the Architect Graphical Interface.






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






23. The Attribute Form maps to different column names in multiple tables






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






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






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






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






28. Columns - Tables






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






30. All Attributes must have an _______.






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






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






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






34. AND - OR - OR NOT - AND NOT






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






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






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






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






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






40. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse






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






42. Tables - Facts - Attributes - Hierarchies






43. OLTP retains data ________






44. A shortcut to an existing Object in a Project






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






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






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






48. OLAP retains data ________






49. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






50. The System Hierarchy is automatically updated whenever you make a change to an __________________.