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. Prompts to select a single value on which to qualify a date - number or text string.






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






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






4. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






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






6. It contains the ID column of the parent attribute






7. OLAP retains data ________






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






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






10. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






11. A subset of a report that users can manipulate without altering the SQL

Warning: Invalid argument supplied for foreach() in /var/www/html/basicversity.com/show_quiz.php on line 183


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






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






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






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






16. Facts - Attributes - Hierarchies






17. Attribute Creation Wizard - Attribute Editor






18. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






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






20. Simple - Derived






21. A condition data must meet in order to be included in a report. Does affect the SQL.






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






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






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






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






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






27. ID columns - Description columns - Fact columns






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






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






30. Columns - Tables






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






32. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






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






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






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






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






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






38. Primary keys






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






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






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






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






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






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






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






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






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






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






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






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