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. Folder List - Object Viewer - Shortcut Bar






2. Simple - Derived






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






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






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






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






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






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






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


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






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






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






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






14. OLTP retains data ________






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






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






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






18. Store info on relationships between 2 or more tables (attributes) - like an Index table.






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






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






21. A method of organizing the appearance of report results in a Grid report based on a criteria






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






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






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






25. Descriptive data that provides context for Facts.






26. Columns - Tables






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






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






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






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






31. It contains the ID column of the parent attribute






32. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






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






34. Subtotals reflect accumulations at selected attribute levels






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






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






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






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






39. Template - Filter - View of a Report






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






41. ID columns - Description columns - Fact columns






42. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






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






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






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






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






47. Attribute Creation Wizard - Attribute Editor






48. Used to modify a Report






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






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