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. Top menu/dropdowns - Toolbar - Right-click popup menus






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






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






4. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






5. Attribute Creation Wizard - Attribute Editor






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






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






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






9. A shortcut to an existing Object in a Project






10. Create the Project Source - Create the Database Instance






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






12. OLAP retains data ________






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






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






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






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






17. Enables you to rearrange the columns and rows in a report.






18. The default entry-points.






19. Compound - Homogeneous - Heterogeneous






20. The System Hierarchy is automatically updated whenever you make a change to an __________________.






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






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






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






24. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






25. You can _____________ in the Architect Graphical Interface.






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






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






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






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






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






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






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






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






34. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format






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






36. Tables - Facts - Attributes - Hierarchies






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






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






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






40. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






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






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






43. Columns - Tables






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






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






46. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






47. Metrics that perform multiple aggregations; one calculation inside of another.






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






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






50. Schema Objects - Application Objects - Configuration Objects







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