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. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






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






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






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






5. Attribute Creation Wizard - Attribute Editor






6. Used to modify a Report






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






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






9. How users can share comments for reports to other users






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






11. All Attributes must have an _______.






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






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






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






15. Less storage - Simple SQL - Complex ETL






16. Prompts to select a single value on which to qualify a date - number or text string.






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






18. All report-level options overwrite ___________.






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






20. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.






21. Create the Project Source - Create the Database Instance






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






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






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






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






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






27. Descriptive data that provides context for Facts.






28. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






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






30. One that uses 2 or more columns as its ID






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






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






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






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






35. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






36. Must have a one-to-one relationship with all other forms.






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






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






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






40. OLTP data storage measure






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






42. View Filters can only ___________.






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






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






45. The Attribute Form maps to the same column name in multiple tables






46. A shortcut to an existing Object in a Project






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






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






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






50. Grid View - Graph View - Grid/Graph View - SQL View