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 detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






2. Compound - Homogeneous - Heterogeneous






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






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






5. OLTP data storage measure






6. More storage - Complex SQL - Simple ETL






7. Used to "fine-tune" your Project






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






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






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






11. Less storage - Simple SQL - Complex ETL






12. Homogeneous - Heterogeneous






13. Grid View - Graph View - Grid/Graph View - SQL View






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






15. Used to modify a Report






16. Template - Filter - View of a Report






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






18. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






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






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






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






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






23. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






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






25. OLAP retains data ________






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






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






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






29. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






30. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema






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






32. A Project Source can house ________ . A single Metadata can be used by multiple Projects.






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


34. Facts - Attributes - Hierarchies






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






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






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






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






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






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






41. ID columns - Description columns - Fact columns






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






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






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






45. Tables - Facts - Attributes - Hierarchies






46. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.






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






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






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






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