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. Top menu/dropdowns - Toolbar - Right-click popup menus






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






3. Homogeneous - Heterogeneous






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






5. It contains the ID column of the parent attribute






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






7. AND - OR - OR NOT - AND NOT






8. Reduced number of JOINS in the generated SQL






9. A shortcut to an existing Object in a Project






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






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






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






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






14. OLAP retains data ________






15. OLAP data storage measure






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






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






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






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






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






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






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






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






24. The default entry-points.






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






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






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






28. Compound - Homogeneous - Heterogeneous






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






30. Level of OLAP integration






31. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






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






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






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






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






36. Less storage - Simple SQL - Complex ETL






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






38. Schema Objects - Application Objects - Configuration Objects






39. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.






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






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






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






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






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






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






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






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






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






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






50. Simple - Derived







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