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. Store info on relationships between 2 or more tables (attributes) - like an Index table.






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






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






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






5. Columns - Tables






6. Enables you to rearrange the columns and rows in a report.






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






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






9. View Filters can only ___________.






10. Folder List - Object Viewer - Shortcut Bar






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






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






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






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






15. OLAP Services does not add any ______ to the report query.






16. Prompts to select a single value on which to qualify a date - number or text string.






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






18. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...






19. More storage - Complex SQL - Simple ETL






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






21. Facts - Attributes - Hierarchies






22. Reduced number of JOINS in the generated SQL






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






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






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






26. A user interface for creating and maintaining a BI environment






27. Used to "fine-tune" your Project






28. Descriptive data that provides context for Facts.






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






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






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






32. The Attribute Form maps to different column names in multiple tables






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






34. The intersection between a data-warehouse - Metadata repository and a user community. It contains objects such as reports - filters - templates and metrics.






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






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






37. Creating multiple attributes quickly. Used during the initial project creation.






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






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






40. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






41. Must have a one-to-one relationship with all other forms.






42. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






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






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






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






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






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






48. Compound - Homogeneous - Heterogeneous






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






50. Level of OLTP integration