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






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






3. Enables you to search for a specific Object or group of Objects that meet a certain criteria.






4. All Attributes must have an _______.






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






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






7. What tool do you use to create the Metadata shell?






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






9. Top menu/dropdowns - Toolbar - Right-click popup menus






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






11. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound






12. Facts - Attributes - Hierarchies






13. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






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






15. Level of OLAP integration






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






17. Simple - Compound - Nested - Derived






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






19. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.






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






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






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






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






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






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






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






27. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents






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






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






30. The actual column name for a fact. Every fact must have at least 1 expression.






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






32. OLAP retains data ________






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






34. Simple - Derived






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






36. A new tool for project design tasks - used for fine-tuning a project after initial creation






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






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


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






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






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






42. Create the Project Source - Create the Database Instance






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






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






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






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






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






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






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






50. Attribute Creation Wizard - Attribute Editor