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. It contains links to specific folders in the Folder List






2. An environment in which the MSTR Desktop connects to the MSTR Intelligence Server (or iServer) - which connects to the Metadata database.






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






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






5. Tables - Facts - Attributes - Hierarchies






6. Homogeneous - Heterogeneous






7. Facts associated to the same column name in 1 or more tables






8. Used to "fine-tune" your Project






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






10. All report-level options overwrite ___________.






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






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






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






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






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






16. Desktop (2 versions: Designer and Analyst) - Architect - Administrative Functions






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






18. What tool do you use to create the Metadata DSN connection?






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






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






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






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






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






24. View Filters are saved with the _____________.






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






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






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






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






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






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






31. Columns - Tables






32. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






33. Grid View - Graph View - Grid/Graph View - SQL View






34. Reduced number of JOINS in the generated SQL






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






36. Subtotals reflect accumulations at selected attribute levels






37. Store info on relationships between 2 or more tables (attributes) - like an Index table.






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






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






40. Used to limit a possibly overwhelming set of potential prompt answers






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






42. Create attribute ID form - Create attribute description forms - Select lookup table(s) - Create attribute relationships






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






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






45. Groupings of directly related attributes. Also commonly known as "dimensions".






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






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






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






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






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