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. User reporting requirements - Query performance - Data volume - DB Maintenance






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






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






4. How users can share comments for reports to other users






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






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






7. ID columns - Description columns - Fact columns






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






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






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






11. Extraction - transformation - loading






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






13. OLAP retains data ________






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






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






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






17. Facts - Attributes - Hierarchies






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






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






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






21. Used to "fine-tune" your Project






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






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






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






25. The Attribute Form Expression that maps to multiple columns from the same table. May also contain an operator (aggregation).






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






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






28. OLAP data storage measure






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






30. View Filters can only ___________.






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






32. Simple - Compound - Nested - Derived






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






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






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






36. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts






37. Top menu > View > Page-by - Drag-&-Drop categories onto the Page-by field window - Right-click a category and "move" to Page-by field






38. Metrics that perform multiple aggregations; one calculation inside of another.






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






40. A shortcut to an existing Object in a Project






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






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






43. Attribute Qualification: A condition an attribute element must meet - Set Qualification: To restrict report results based on a Metric - Shortcut to a Report: A resultset of an existing report - Shortcut to a Filter: To use 1 or more existing filters






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






45. Up: To see data at a higher-level attribute of the same hierarchy - Down: To see data at a lower-level attribute of the same hierarchy - Other Directions: To see data at any level of any hierarchy






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






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






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






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






50. Metrics you create within a report using only those objects in the report.







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