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. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded






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






3. Schema Objects - Application Objects - Configuration Objects






4. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked






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






6. Filter definition prompts - Object prompts - Value prompts - Level prompts






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






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






9. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition






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






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






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






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






14. Columns - Tables






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






16. Used for - Initially populating the Metadata - Creating schema objects






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






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






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






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






21. Used to create or edit complex attributes - facts - hierarchies - and logical tables






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






23. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






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






25. It contains the ID column of the parent attribute






26. More storage - Complex SQL - Simple ETL






27. The Attribute Form maps to different column names in multiple tables






28. A subset of a report that users can manipulate without altering the SQL

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


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






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






31. View Filters are saved with the _____________.






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






33. Level of OLTP integration






34. Used to "fine-tune" your Project






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






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






37. You can e-mail reports by going to _____






38. AND - OR - OR NOT - AND NOT






39. OLAP retains data ________






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






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






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






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






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






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






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






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






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






49. Creating multiple attributes quickly. Used during the initial project creation.






50. Compound - Homogeneous - Heterogeneous