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. Direct: 2-tier - Server: 3-tier






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






3. Reduced number of JOINS in the generated SQL






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






5. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.






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






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






8. Cube analysis - Derived elements - In-memory OLAP with use of report objects - View filters - Derived metrics






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






10. Seach for - Object name - Object ID - Object location - Object date range - Object type - Object owner






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






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






13. All report-level options overwrite ___________.






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






15. OLAP retains data ________






16. OLTP data storage measure






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






18. Template - Filter - View of a Report






19. A subset of a report that users can manipulate without altering the SQL


20. An add-on product to the Intelligence Server to greatly enhance the type of analysis you can perform






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






22. Attribute Creation Wizard - Attribute Editor






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






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






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






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






27. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






28. AND - OR - OR NOT - AND NOT






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






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






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






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






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






34. Create the Project Source - Create the Database Instance






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






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






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






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






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






40. Compound - Homogeneous - Heterogeneous






41. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications






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






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






44. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






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






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






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






48. User reporting requirements - Query performance - Data volume - DB Maintenance






49. Grid View - Graph View - Grid/Graph View - SQL View






50. Subtotals reflect accumulations at selected attribute levels