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


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






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






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






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






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






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






8. You can e-mail reports by going to _____






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






10. Columns - Tables






11. Subtotals reflect accumulations at selected attribute levels






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






13. Primary keys






14. OLAP data storage measure






15. Facts associated to different column names in 2 or more tables






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






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






18. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






19. Using the Prompt Generation Wizard - Inside the Report Editor






20. Used to limit a possibly overwhelming set of potential prompt answers






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






22. Used to "fine-tune" your Project






23. The default entry-points.






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






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






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






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






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






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






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






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






32. AND - OR - OR NOT - AND NOT






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






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






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






36. OLTP retains data ________






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






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






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






40. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






41. Facts - Attributes - Hierarchies






42. Simple - Derived






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






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






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






46. ID columns - Description columns - Fact columns






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






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






49. All report-level options overwrite ___________.






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