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. Schema Objects - Application Objects - Configuration Objects






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






3. Specifies what info to retrieve from a data-warehouse - and how to display it






4. It contains the ID column of the parent attribute






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






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






7. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






8. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






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






10. Subtotals reflect accumulations at selected attribute levels






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






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






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






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






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






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






17. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.






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






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






20. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






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






22. Template - Filter - View of a Report






23. The unique values of an attribute obtained from the data-warehouse






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






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






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






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






28. Simple - Derived






29. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save






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






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






32. The default entry-points.






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






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






35. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






36. A condition data must meet in order to be included in a report. Does affect the SQL.






37. Enables you to format report values based on a condition - such as highlights - font colors - etc.






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


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






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






41. Less storage - Simple SQL - Complex ETL






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






43. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling






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






45. All report-level options overwrite ___________.






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






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






48. Enables you to search for a specific Object or group of Objects that meet a certain criteria.






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






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