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. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






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






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






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






5. Descriptive data that provides context for Facts.






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






7. You can _____________ in the Architect Graphical Interface.






8. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






9. The default entry-points.






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






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






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






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






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






15. OLTP data storage measure






16. It contains the ID and DESC columns of all higher-level attributes






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






18. Reduced number of JOINS in the generated SQL






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






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






21. All report-level options overwrite ___________.






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






23. More storage - Complex SQL - Simple ETL






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






25. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.






26. OLAP retains data ________






27. Level of OLTP integration






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






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






30. OLTP retains data ________






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






32. The Attribute Form Expression that maps to a single column - no matter the number of tables






33. Template - Filter - View of a Report






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






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






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






37. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound






38. Allow you to interact with the BI system - logically organize data to analyze complex relationships






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






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






41. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






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






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






44. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)






45. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.






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


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






48. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.






49. Simple - Compound - Nested - Derived






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