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. Enables you to format report values based on a condition - such as highlights - font colors - etc.






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






3. Architect Graphical Interface _____________ - Does not support transformations or other advanced architect techniques - Does not auto-save






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






5. What tool do you use to create the Metadata DSN connection?






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






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






8. AND - OR - OR NOT - AND NOT






9. More storage - Complex SQL - Simple ETL






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






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






12. A feature that enables users to delivers reports to the history list - cache or mobile






13. Used to modify a Report






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






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






16. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling






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






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






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






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






21. View Filters are saved with the _____________.






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






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






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






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






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






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






28. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






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






30. Attribute Creation Wizard - Attribute Editor






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






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






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






34. A Project Source can house ________ . A single Metadata can be used by multiple Projects.






35. Descriptive data that provides context for Facts.






36. A condition data must meet - created "on-the-fly" - in order to be included in a report. Does not affect the SQL.






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






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






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






40. Schema Objects - Application Objects - Configuration Objects






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






42. 3 Ways: - Metric Value: Qualifies on a Metric value - Rank: Qualifies on a numeric rank of Metric values - Percent: Qualifies on the % of a Metric value being ranked






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






44. Subtotals reflect accumulations at selected attribute levels






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






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






47. Create the Project Source - Create the Database Instance






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






49. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded






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