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. Reduced number of JOINS in the generated SQL






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






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






4. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






5. The default entry-points.






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






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






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






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






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






11. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






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






13. AND - OR - OR NOT - AND NOT






14. Facts - Attributes - Hierarchies






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






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






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






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






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






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






21. Attribute Creation Wizard - Attribute Editor






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






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






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






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. One that uses 2 or more columns as its ID






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






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






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






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






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






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






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






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






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






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






37. How users can share comments for reports to other users






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






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






40. Subtotals reflect accumulations at selected attribute levels






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






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






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






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






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






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






47. Simple - Compound - Nested - Derived






48. All Attributes must have an _______.






49. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






50. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.