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. Metrics aggregate on the lowest-level attribute __________.






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






3. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






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






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






6. Attribute Creation Wizard - Attribute Editor






7. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.






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






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






10. A shortcut to an existing Object in a Project






11. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






12. Less storage - Simple SQL - Complex ETL






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






14. Enables you to format report values based on a condition - such as highlights - font colors - etc.






15. Simple - Compound - Nested - Derived






16. All Attributes must have an _______.






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






18. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters






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






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






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






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






23. Used to dynamically alter the contents of a report. With prompts - you can determine at run-time the objects you want to retreive for a report and filtering conditions.






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






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






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






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






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






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






30. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






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






32. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






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






34. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






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






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






37. Enables you to rearrange the columns and rows in a report.






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






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






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






41. Used to modify a Report






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






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






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






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






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






47. Create the Project Source - Create the Database Instance






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






49. Reduced number of JOINS in the generated SQL






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