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. Facts associated to different column names in 2 or more tables






2. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






3. Extraction - transformation - loading






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






5. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.






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






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






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






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






10. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse






11. You must select "Other directions" when drilling attributes while viewing a report






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






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






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






15. Compound - Homogeneous - Heterogeneous






16. Contains info that facilitates the transfer of data from the source systems to the data-warehouse






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






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






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






20. Folder List - Object Viewer - Shortcut Bar






21. All Attributes must have an _______.






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






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






24. Simple - Derived






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






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






27. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition






28. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






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






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






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






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






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






34. It contains the ID column of the parent attribute






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






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






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






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






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






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






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






42. Prompts to select a single value on which to qualify a date - number or text string.






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






44. Filter definition prompts - Object prompts - Value prompts - Level prompts






45. Reduced number of JOINS in the generated SQL






46. It contains the ID column of all higher-level attributes






47. Columns - Tables






48. Used to modify a Report






49. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






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