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. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






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






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






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






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






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






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






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






9. Formula - Level (Dimensionality) - Conditionality - Transformation






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






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






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






13. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






15. To see data at completely different levels - other than that of the original Grid or Graph






16. Specifies what info to retrieve from a data-warehouse - and how to display it






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






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






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






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






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






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






23. View Filters can only ___________.






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






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






26. Attribute Creation Wizard - Attribute Editor






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






28. ID columns - Description columns - Fact columns






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






30. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






31. The default entry-points.






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






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






34. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






35. More storage - Complex SQL - Simple ETL






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






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






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






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






40. Extraction - transformation - loading






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






42. OLTP data storage measure






43. You can _____________ in the Architect Graphical Interface.






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






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






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






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






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






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






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