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. Attribute Creation Wizard - Attribute Editor






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






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






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






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






6. Enables you to select and display subsets of a report as separate pages.






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






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






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






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






11. Facts - Attributes - Hierarchies






12. ID columns - Description columns - Fact columns






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






14. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships






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






16. The default entry-points.






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






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






19. It contains the ID column of the parent attribute






20. Homogeneous - Heterogeneous






21. Grid View - Graph View - Grid/Graph View - SQL View






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






23. Tables - Facts - Attributes - Hierarchies






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






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






26. Less storage - Simple SQL - Complex ETL






27. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






28. Extraction - transformation - loading






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






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






31. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






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






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






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






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






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






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






38. A shortcut to an existing Object in a Project






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






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






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






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






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






44. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






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






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






47. View Filters can only ___________.






48. Compound - Homogeneous - Heterogeneous






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






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