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. What tool do you use to create the Metadata DSN connection?






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






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






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






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






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






7. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






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






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






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






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






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






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






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






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






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






17. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






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






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






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






21. All report-level options overwrite ___________.






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






23. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






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






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






26. Simple - Derived






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






28. User requirements - Existing source data - Technical and performance considerations






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






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






31. Reduced number of JOINS in the generated SQL






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






33. Simple - Compound - Nested - Derived






34. View Filters are saved with the _____________.






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






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






37. AND - OR - OR NOT - AND NOT






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






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






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






41. A development environment to create BI applications - allowing users to edit the Metadata database






42. Tables - Facts - Attributes - Hierarchies






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






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






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






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






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






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






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






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