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. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






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






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






4. Create the Project Source - Create the Database Instance






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






6. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






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






8. View Filters can only ___________.






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






10. Attributes must be homogeneous - Attributes can only have simple form expressions - No more than 2 attribute forms (usually an ID and primary description)






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






12. Facts - Attributes - Hierarchies






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






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






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






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






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






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






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






20. More storage - Complex SQL - Simple ETL






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






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






23. A new tool for project design tasks - used for fine-tuning a project after initial creation






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






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






26. Template - Filter - View of a Report






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






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






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






30. An environment in which the MSTR Desktop connects directly to the Metadata database.






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






32. A full-featured version that enables Report Developers to design complex and sophisticated reports and documents






33. Reduced number of JOINS in the generated SQL






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






35. Used to "fine-tune" your Project






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






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






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






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






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






41. Homogeneous - Heterogeneous






42. Level of OLAP integration






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






44. Compound - Homogeneous - Heterogeneous






45. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






46. All report-level options overwrite ___________.






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






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






49. Simple: Single column unique identifier - Compound: 2 or more columns per unique identifier






50. Filter definition prompts - Object prompts - Value prompts - Level prompts







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests