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. The Attribute Form maps to different column names in multiple tables






2. Contains info that facilitates the transfer of data from the source systems to the data-warehouse






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






4. The default entry-points.






5. OLAP data storage measure






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






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


8. More storage - Complex SQL - Simple ETL






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






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






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






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






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






14. It contains the ID column of all higher-level attributes






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






16. Facts - Attributes - Hierarchies






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






18. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






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






20. Simple - Derived






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






22. Used for - Initially populating the Metadata - Creating schema objects






23. Used to "fine-tune" your Project






24. Grid View - Graph View - Grid/Graph View - SQL View






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






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






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






28. Used to modify a Report






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






30. All Attributes must have an _______.






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






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






33. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling






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






35. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.






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






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






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






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






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






42. Create the Project Source - Create the Database Instance






43. Tables - Facts - Attributes - Hierarchies






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






45. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts






46. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






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






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






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






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