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. AND - OR - OR NOT - AND NOT






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






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






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






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






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






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






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






9. Descriptive data that provides context for Facts.






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






11. Formula - Level (Dimensionality) - Conditionality - Transformation






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






13. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






14. Facts - Attributes - Hierarchies






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






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






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






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






19. You can _____________ in the Architect Graphical Interface.






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






21. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier






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






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






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






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






26. The default entry-points.






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






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






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






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






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






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






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






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






35. Level of OLAP integration






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






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






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






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






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






41. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






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






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






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






45. Schema Objects - Application Objects - Configuration Objects






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






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






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






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






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