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. ID columns - Description columns - Fact columns






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






3. Columns - Tables






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






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






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






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






8. Attribute Creation Wizard - Attribute Editor






9. Used to "fine-tune" your Project






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






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






12. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.






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






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






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






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






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






18. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






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






20. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






21. Used to limit a possibly overwhelming set of potential prompt answers






22. User requirements - Existing source data - Technical and performance considerations






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






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






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






26. Level of OLAP integration






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






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






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






30. Template - Filter - View of a Report






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






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






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






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






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






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






37. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.






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






39. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters






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






41. Schema Objects - Application Objects - Configuration Objects






42. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






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






44. OLAP retains data ________






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






46. Specifies a condition data must meet in order to be included in a report






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






48. Less storage - Simple SQL - Complex ETL






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






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