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. Enables you to rearrange the columns and rows in a report.






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






3. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format






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. Extraction - transformation - loading






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






7. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






8. The Attribute Form Expression that maps to a single column - no matter the number of tables






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






10. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






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






12. AND - OR - OR NOT - AND NOT






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






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






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






16. The default entry-points.






17. Facts associated to the same column name in 1 or more tables






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






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






20. You can _____________ in the Architect Graphical Interface.






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






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






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






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






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






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






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






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






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






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






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






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






33. The Attribute Form maps to the same column name in multiple tables






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






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






36. View Filters are saved with the _____________.






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






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






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






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






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






42. It contains the ID column of the parent attribute






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






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






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






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






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






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






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






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