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. User reporting requirements - Query performance - Data volume - DB Maintenance






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






3. A Project Source can house ________ . A single Metadata can be used by multiple Projects.






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






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






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






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






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






9. Primary keys






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






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






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






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






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






15. Formula - Level (Dimensionality) - Conditionality - Transformation






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






17. Used to "fine-tune" your Project






18. Simple - Compound - Nested - Derived






19. Attribute Creation Wizard - Attribute Editor






20. Subtotals reflect accumulations at selected attribute levels






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






22. Columns - Tables






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






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






25. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier






26. Create the Project Source - Create the Database Instance






27. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save






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






29. The default entry-points.






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






31. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






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






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






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






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






36. OLTP retains data ________






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






38. Using the Prompt Generation Wizard - Inside the Report Editor






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






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






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






42. Specifies a condition data must meet in order to be included in a report






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






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






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






46. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






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






48. It contains links to specific folders in the Folder List






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






50. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)