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. Level of OLTP integration






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






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






4. MS Excel - MS Word - MS Access - PDF - HTML - Plain text






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






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






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






8. Provide convenient paths for browsing attribute data - as defined by the user. They don't follow the logical model. May not consist of directly related attributes.






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






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






11. Facts - Attributes - Hierarchies






12. Enables "indented" grouping of related attributes. Useful for displaying a report at different levels quickly.






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






14. Homogeneous - Heterogeneous






15. Simple - Derived






16. Columns - Tables






17. Grid View - Graph View - Grid/Graph View - SQL View






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






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






20. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






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






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






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






24. Descriptive data that provides context for Facts.






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






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






27. A shortcut to an existing Object in a Project






28. The default entry-points.






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






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






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






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






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






34. Extraction - transformation - loading






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






36. OLAP retains data ________






37. It contains the ID column of all higher-level attributes






38. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.






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






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






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






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






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






44. OLTP data storage measure






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






46. You can _____________ in the Architect Graphical Interface.






47. Tables - Facts - Attributes - Hierarchies






48. Simple - Compound - Nested - Derived






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






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






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