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. Groupings of directly related attributes. Also commonly known as "dimensions".






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






4. Reduced number of JOINS in the generated SQL






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






6. Level of OLTP integration






7. You can _____________ in the Architect Graphical Interface.






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






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






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






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






12. OLTP data storage measure






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






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






15. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships






16. A development environment to create BI applications - allowing users to edit the Metadata database






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






18. OLAP data storage measure






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






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






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






22. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






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






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






25. More storage - Complex SQL - Simple ETL






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






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






28. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






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






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






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






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






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






34. Enables you to select and display subsets of a report as separate pages.






35. Compound - Homogeneous - Heterogeneous






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






37. Tables - Facts - Attributes - Hierarchies






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






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






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






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






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






43. Used to modify a Report






44. OLAP retains data ________






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






46. Must have Subtotals enabled - or you won't see any data for higher-level attributes






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






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






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






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







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