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






2. Simple - Derived






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






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






5. Descriptive data that provides context for Facts.






6. Enables you to rearrange the columns and rows in a report.






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. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






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






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






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






12. You must select "Other directions" when drilling attributes while viewing a report






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






14. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






15. Used to modify a Report






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






17. Reduced number of JOINS in the generated SQL






18. Extraction - transformation - loading






19. You can _____________ in the Architect Graphical Interface.






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






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






22. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.






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






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






25. View Filters are saved with the _____________.






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






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






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






29. Simple - Compound - Nested - Derived






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






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






32. One that uses 2 or more columns as its ID






33. The logical associations between attributes that exist based on a business rule






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






35. OLAP data storage measure






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






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






38. Facts - Attributes - Hierarchies






39. Less storage - Simple SQL - Complex ETL






40. OLAP Services does not add any ______ to the report query.






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






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






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






44. Used to "fine-tune" your Project






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






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






47. Create the Project Source - Create the Database Instance






48. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






49. Needed to create other application objects - like reports or documents - such as templates - filters - metrics - etc.






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