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. A development environment to create BI applications - allowing users to edit the Metadata database






2. May include 1 or more functions as operators - Based on the attributes and metrics in the Report Objects window - May be Simple or Compound






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






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






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






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






7. Tables - Facts - Attributes - Hierarchies






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






9. You can _____________ in the Architect Graphical Interface.






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






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






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






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






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






15. ID columns - Description columns - Fact columns






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






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






18. Attribute Creation Wizard - Attribute Editor






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






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






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






22. OLAP retains data ________






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






24. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






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






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






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






28. Simple - Derived






29. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).






30. Level of OLTP integration






31. Descriptive data that provides context for Facts.






32. Grid View - Graph View - Grid/Graph View - SQL View






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






34. Fact Creation Wizard: Used to create simple - homogeneous facts - Fact Editor: Used to create derived - heterogeneous facts






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






36. They store the column data type - and must be changed when creating a derived fact expression with conflicting data types






37. Folder List - Object Viewer - Shortcut Bar






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






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






40. Simple - Compound - Nested - Derived






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






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






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






44. Extraction - transformation - loading






45. Used to create or edit complex attributes - facts - hierarchies - and logical tables






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






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






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






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






50. Metrics you create within a report using only those objects in the report.