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. Made up of attributes - facts - metrics - etc. that make up the Metadata. All project info is stored in the Metadata.






2. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






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






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






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






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






7. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






8. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






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






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






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






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






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






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






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






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






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






19. View Filters are saved with the _____________.






20. Enables you to select which tables from the data-warehouse to store in the Metadata database






21. Enables you to lock column headers so that they always appear when scrolling






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






23. Facts - Attributes - Hierarchies






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






25. Folder List - Object Viewer - Shortcut Bar






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






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






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






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






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






31. Data is read-only - Data is aligned by business subject - Data formatting is uniform - Data is long-term data (2-5+ years)






32. You must select "Other directions" when drilling attributes while viewing a report






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






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






35. Primary keys






36. What tool do you use to create the Metadata shell?






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






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






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






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






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






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






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






44. Grid View - Graph View - Grid/Graph View - SQL View






45. Compound - Homogeneous - Heterogeneous






46. OLAP data storage measure






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






48. A method of organizing the appearance of report results in a Grid report based on a criteria






49. Subtotals reflect accumulations at selected attribute levels






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







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