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. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






2. The default entry-points.






3. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






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






5. Grid View - Graph View - Grid/Graph View - SQL View






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






7. Extraction - transformation - loading






8. The System Hierarchy is automatically updated whenever you make a change to an __________________.






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






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






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






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






13. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).






14. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.






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






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






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






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






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






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






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






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






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






24. Used to create or edit complex attributes - facts - hierarchies - and logical tables






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






26. ID columns - Description columns - Fact columns






27. Create the Project Source - Create the Database Instance






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






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






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






31. User reporting requirements - Query performance - Data volume - DB Maintenance






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






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






34. Level of OLAP integration






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






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






37. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters






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






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






40. You can _____________ in the Architect Graphical Interface.






41. Reduced number of JOINS in the generated SQL






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






43. Enables you to search for a specific Object or group of Objects that meet a certain criteria.






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






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






46. To see data at completely different levels - other than that of the original Grid or Graph






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






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






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






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







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