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. A user interface for creating and maintaining a BI environment






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






3. It contains the ID column of all higher-level attributes






4. More storage - Complex SQL - Simple ETL






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






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






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






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






9. Descriptive data that provides context for Facts.






10. ID columns - Description columns - Fact columns






11. Template - Filter - View of a Report






12. Grid View - Graph View - Grid/Graph View - SQL View






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






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






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






16. OLTP retains data ________






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






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






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






20. The logical associations between attributes that exist based on a business rule






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






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






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






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






25. A feature that enables users to delivers reports to the history list - cache or mobile






26. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






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






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






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






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






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






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






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






34. What tool do you use to create the Metadata DSN connection?






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






36. Specifies what info to retrieve from a data-warehouse - and how to display it






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






38. Simple - Compound - Nested - Derived






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






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






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






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






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






44. View Filters can only ___________.






45. Compound - Homogeneous - Heterogeneous






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






47. It contains the ID column of the parent attribute






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






49. Attribute Creation Wizard - Attribute Editor






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