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. A condition data must meet in order to be included in a report. Does affect the SQL.






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






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






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






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






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






7. Direct: 2-tier - Server: 3-tier






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






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






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






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






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






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






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






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






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






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






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






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






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






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






22. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






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






24. Less storage - Simple SQL - Complex ETL






25. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






26. Template - Filter - View of a Report






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






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






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






30. The default entry-points.






31. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






32. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.






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






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






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






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






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






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






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






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






41. Folder List - Object Viewer - Shortcut Bar






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






43. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






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






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






46. All Attributes must have an _______.






47. The Attribute Form Expression that maps to a single column - no matter the number of tables






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






49. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.






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