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. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






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






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






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






5. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






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






7. Facts - Attributes - Hierarchies






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






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






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






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






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






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






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






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






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






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






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






19. Reduced number of JOINS in the generated SQL






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






21. Simple - Compound - Nested - Derived






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






23. OLAP data storage measure






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






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






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






27. Compound - Homogeneous - Heterogeneous






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






29. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






30. To see data at completely different levels - other than that of the original Grid or Graph






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






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






33. Used to limit a possibly overwhelming set of potential prompt answers






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






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






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






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






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






39. Must have a one-to-one relationship with all other forms.






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






41. View Filters can only ___________.






42. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts






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






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






45. Primary keys






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






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






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






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. It contains the ID and DESC columns of all higher-level attributes