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. Allow you to interact with the BI system - logically organize data to analyze complex relationships






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






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






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






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






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






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






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






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






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






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






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






13. View Filters are saved with the _____________.






14. Columns - Tables






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






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






17. AND - OR - OR NOT - AND NOT






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






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






20. Used to modify a Report






21. ID columns - Description columns - Fact columns






22. Template - Filter - View of a Report






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






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






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






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






27. Store info on relationships between 2 or more tables (attributes) - like an Index table.






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






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






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






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






32. Schema Objects - Application Objects - Configuration Objects






33. View Filters can only ___________.






34. OLTP data storage measure






35. Less storage - Simple SQL - Complex ETL






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






37. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.






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






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






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






41. Reduced number of JOINS in the generated SQL






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






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






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






45. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






46. Homogeneous - Heterogeneous






47. OLAP data storage measure






48. Used for - Initially populating the Metadata - Creating schema objects






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






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