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. Using the Prompt Generation Wizard - Inside the Report Editor






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






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






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






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






6. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






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






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






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






10. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.






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






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






13. You can _____________ in the Architect Graphical Interface.






14. A development environment to create BI applications - allowing users to edit the Metadata database






15. Columns - Tables






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






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






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






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






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






21. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






22. Top menu/dropdowns - Toolbar - Right-click popup menus






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






24. What tool do you use to create the Metadata shell?






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






26. All report-level options overwrite ___________.






27. Simple - Compound - Nested - Derived






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






29. Facts associated to the same column name in 1 or more tables






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






31. Schema Objects - Application Objects - Configuration Objects






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






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






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






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






36. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






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






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






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






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






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






42. Create the Project Source - Create the Database Instance






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






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






45. A diagram that shows the information you want to analyze in a project and how that information is related. It depicts the flow of data in an organization. It is not based on the physical structure of the data-warehouse. Used by the MSTR Engine to gen






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






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






48. OLTP retains data ________






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






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







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