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. Define browsing attributes - Set entry-points - Set element display - Define attribute filters - Configure for drilling - Define the sort order for browsing - Define the sort order for drilling






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






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






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






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






6. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition






7. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts






8. You can _____________ in the Architect Graphical Interface.






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






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






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






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






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






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






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






16. Folder List - Object Viewer - Shortcut Bar






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






18. Less storage - Simple SQL - Complex ETL






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






20. Facts are _____ in the data-warehouse. In MSTR - you created fact schema objects which reference those facts stored in the warehouse






21. Compound - Homogeneous - Heterogeneous






22. AND - OR - OR NOT - AND NOT






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






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






25. OLTP data storage measure






26. Subtotals reflect accumulations at selected attribute levels






27. Using the Prompt Generation Wizard - Inside the Report Editor






28. Schema Objects - Application Objects - Configuration Objects






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






30. Specifies a condition data must meet in order to be included in a report






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






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






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






34. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy






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






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






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






38. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema






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






40. Template - Filter - View of a Report






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






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






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






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






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






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






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






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






49. Tables - Facts - Attributes - Hierarchies






50. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:



Major Subjects



Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Most popular tests