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. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






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






3. ID columns - Description columns - Fact columns






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






5. Descriptive data that provides context for Facts.






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






7. You can _____________ in the Architect Graphical Interface.






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






9. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






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






11. All report-level options overwrite ___________.






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


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






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






15. Facts - Attributes - Hierarchies






16. Columns - Tables






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






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






19. A user interface for creating and maintaining a BI environment






20. Reduced number of JOINS in the generated SQL






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






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






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






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






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






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






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






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






29. Creating multiple attributes quickly. Used during the initial project creation.






30. OLAP retains data ________






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






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






33. Level of OLAP integration






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






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






36. Used to "fine-tune" your Project






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






38. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.






39. Simple - Derived






40. Used to modify a Report






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






42. Extraction - transformation - loading






43. View Filters can only ___________.






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






45. It contains the ID column of the parent attribute






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






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






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






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






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