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. Must have Subtotals enabled - or you won't see any data for higher-level attributes






3. Used to modify a Report






4. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships






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






6. 1 - Form definition 2 - Form general info 3 - Form category 4 - Form format






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






8. An environment in which the MSTR Desktop connects directly to the Metadata database.






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






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






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






12. Compound - Homogeneous - Heterogeneous






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






14. Metrics aggregate on the lowest-level attribute __________.






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






16. How users can share comments for reports to other users






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






18. OLAP data storage measure






19. To see data at completely different levels - other than that of the original Grid or Graph






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






21. Simple - Derived






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






23. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner






24. More storage - Complex SQL - Simple ETL






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






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






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






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






29. Create the Project Source - Create the Database Instance






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






31. Less storage - Simple SQL - Complex ETL






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






33. Right-click on the attribute - Double-click it - Click the drill icon from the Toolbar






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. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






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






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






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






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






40. Facts associated to the same column name in 1 or more tables






41. What tool do you use to create the Metadata DSN connection?






42. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






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






44. Primary keys






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






46. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






48. Subtotals reflect accumulations at selected attribute levels






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






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