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. Contains info that facilitates the transfer of data from the source systems to the data-warehouse






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






3. Enables you to format report values based on a condition - such as highlights - font colors - etc.






4. Subtotals reflect accumulations at selected attribute levels






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






6. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






7. Simple - Compound - Nested - Derived






8. OLTP retains data ________






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






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






11. View Filters can only ___________.






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






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






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






15. Primary keys






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






17. Filter definition prompts - Object prompts - Value prompts - Level prompts






18. Less storage - Simple SQL - Complex ETL






19. OLTP data storage measure






20. Top menu/dropdowns - Toolbar - Right-click popup menus






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






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






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






24. More storage - Complex SQL - Simple ETL






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






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






27. It contains the ID column of all higher-level attributes






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






29. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






30. Homogeneous - Heterogeneous






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






32. Facts - Attributes - Hierarchies






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






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






35. Creating multiple attributes quickly. Used during the initial project creation.






36. Columns - Tables






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






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






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






40. View Filters are saved with the _____________.






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






42. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)






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






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






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






46. A condition data must meet in order to be included in a report. Does affect the SQL.






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






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






49. Enables you to specify the order in which the data in a report for a particular row/column appears; ascending or descending






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







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests