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. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






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






3. Create the Project Source - Create the Database Instance






4. Descriptive data that provides context for Facts.






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






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






7. Folder List - Object Viewer - Shortcut Bar






8. Metrics you create within a report using only those objects in the report.






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






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






11. It contains the ID column of the parent attribute






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






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






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






15. Template - Filter - View of a Report






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






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






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






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






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






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






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






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






24. User reporting requirements - Query performance - Data volume - DB Maintenance






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






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






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






28. Used to "fine-tune" your Project






29. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






30. Compound - Homogeneous - Heterogeneous






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






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






33. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






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






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






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






37. A method of organizing the appearance of report results in a Grid report based on a criteria






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






39. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






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






41. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






42. Facts - Attributes - Hierarchies






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






44. View Filters are saved with the _____________.






45. Direct: 2-tier - Server: 3-tier






46. Simple - Compound - Nested - Derived






47. Level of OLTP integration






48. Extraction - transformation - loading






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






50. AND - OR - OR NOT - AND NOT







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests