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. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format






2. ID columns - Description columns - Fact columns






3. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






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






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






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






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






8. The default entry-points.






9. The System Hierarchy is automatically updated whenever you make a change to an __________________.






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






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






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






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






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






15. Schema Objects - Application Objects - Configuration Objects






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






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






18. A new tool for project design tasks - used for fine-tuning a project after initial creation






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






20. Level of OLTP integration






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






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






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






24. It contains the ID column of the parent attribute






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






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






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






28. Contains info that facilitates the transfer of data from the source systems to the data-warehouse






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






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






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






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






33. Columns - Tables






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






35. OLAP data storage measure






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






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






38. Attribute Creation Wizard - Attribute Editor






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






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






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






42. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications






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






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






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






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






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






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






49. OLTP data storage measure






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