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






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






3. Level of OLTP integration






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






5. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)






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






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






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






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






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






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






12. The default entry-points.






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






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






15. OLTP retains data ________






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






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






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






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






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






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






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






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






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






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






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






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






28. Level of OLAP integration






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






30. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






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






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






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






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






35. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.






36. Descriptive data that provides context for Facts.






37. Homogeneous - Heterogeneous






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






39. A condition data must meet in order to be included in a report. Does affect the SQL.






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






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






42. View Filters can only ___________.






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






44. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






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






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






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






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






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






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