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. View Filters are saved with the _____________.






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






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






4. Simple - Derived






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






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






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






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






9. View Filters can only ___________.






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






11. Top menu/dropdowns - Toolbar - Right-click popup menus






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






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






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






15. Enables you to select which tables from the data-warehouse to store in the Metadata database






16. Less storage - Simple SQL - Complex ETL






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






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






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






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






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






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






23. Used to "fine-tune" your Project






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






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






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






27. Attribute Creation Wizard - Attribute Editor






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






29. OLAP Services does not add any ______ to the report query.






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






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. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






33. OLTP data storage measure






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






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






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. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






38. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).






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






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






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






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






43. All report-level options overwrite ___________.






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






45. Metrics that perform multiple aggregations; one calculation inside of another.






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






47. You can _____________ in the Architect Graphical Interface.






48. Metrics aggregate on the lowest-level attribute __________.






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






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