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. Used to create or edit complex attributes - facts - hierarchies - and logical tables






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






4. The report will retreive data for all Objects under the report definition (regardless of whether or not they exist on the template)






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






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






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






8. Simple - Derived






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


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






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






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






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






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






15. OLTP retains data ________






16. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






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






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






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






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






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






22. Allow you to interact with the BI system - logically organize data to analyze complex relationships






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






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






25. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities






26. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






27. A shortcut to an existing Object in a Project






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






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






30. Attribute Creation Wizard - Attribute Editor






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






32. OLTP data storage measure






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






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






35. All Attributes must have an _______.






36. A method of organizing the appearance of report results in a Grid report based on a criteria






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






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






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






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






41. OLAP data storage measure






42. Create the Project Source - Create the Database Instance






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






44. Extraction - transformation - loading






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






46. Descriptive data that provides context for Facts.






47. Folder List - Object Viewer - Shortcut Bar






48. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition






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






50. Columns - Tables