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 condition data must meet in order to be included in a report. Does affect the SQL.






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






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






4. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.






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






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






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






8. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






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






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






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






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






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






14. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






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






16. Primary keys






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






18. OLTP data storage measure






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






20. To define the level of aggregation for a specific metric - Used for qualifications






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






22. Used to modify a Report






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






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






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


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






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






28. OLAP retains data ________






29. Facts - Attributes - Hierarchies






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






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






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






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






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






35. Simple - Derived






36. How users can share comments for reports to other users






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






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






39. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






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






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






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






43. Descriptive data that provides context for Facts.






44. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






45. Used to "fine-tune" your Project






46. Prompts to specify the level of a metric. They are not placed directly on a report - but rather embeded in a metric.






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






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






49. Subtotals reflect accumulations at selected attribute levels






50. Tables - Facts - Attributes - Hierarchies