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. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.






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






3. The Attribute Form Expression that maps to a single column - no matter the number of tables






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






5. Grid View - Graph View - Grid/Graph View - SQL View






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






7. Primary keys






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






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






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






11. Tables - Facts - Attributes - Hierarchies






12. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling






13. Facts - Attributes - Hierarchies






14. Used to "fine-tune" your Project






15. What tool do you use to create the Metadata DSN connection?






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






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






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






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






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






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






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






23. ID columns - Description columns - Fact columns






24. Template - Filter - View of a Report






25. OLTP retains data ________






26. Simple - Derived






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






28. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy






29. Must have Subtotals enabled - or you won't see any data for higher-level attributes






30. Reduced number of JOINS in the generated SQL






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






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






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






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






35. Level of OLAP integration






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






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






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






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. Creating multiple attributes quickly. Used during the initial project creation.






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






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






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






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






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






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






47. Used to create or edit complex attributes - facts - hierarchies - and logical tables






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






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






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







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests