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. Used to create or edit complex attributes - facts - hierarchies - and logical tables






2. Attribute Creation Wizard - Attribute Editor






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






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






5. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.






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






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






8. Used to "fine-tune" your Project






9. Schema Objects - Application Objects - Configuration Objects






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






11. Folder List - Object Viewer - Shortcut Bar






12. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






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






14. Simple - Derived






15. Extraction - transformation - loading






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






17. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents






18. Template - Filter - View of a Report






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






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






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






22. Less storage - Simple SQL - Complex ETL






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






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






25. Tables - Facts - Attributes - Hierarchies






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






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






28. All report-level options overwrite ___________.






29. Homogeneous - Heterogeneous






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






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






32. Enables you to format report values based on a condition - such as highlights - font colors - etc.






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






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






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






36. It contains the ID column of the parent attribute






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






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






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






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






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






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






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






44. You can _____________ in the Architect Graphical Interface.






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






46. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.






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






48. Creating multiple attributes quickly. Used during the initial project creation.






49. Primary keys






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







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:



Major Subjects



Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Most popular tests