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. To define the level of aggregation for a specific metric - Used for qualifications






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






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






4. Compound - Homogeneous - Heterogeneous






5. Folder List - Object Viewer - Shortcut Bar






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






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






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






9. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






10. OLTP data storage measure






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






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






13. ID columns - Description columns - Fact columns






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






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






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






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






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






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






20. AND - OR - OR NOT - AND NOT






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






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






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






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






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






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






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






28. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships






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






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






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






32. The Attribute Form maps to the same column name in multiple tables






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






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






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






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






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






38. Attribute Creation Wizard - Attribute Editor






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






40. Columns - Tables






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






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






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






44. Simple - Derived






45. You must select "Other directions" when drilling attributes while viewing a report






46. All report-level options overwrite ___________.






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






48. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






49. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






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