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






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






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






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






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






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






7. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






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






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






10. OLTP data storage measure






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






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






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






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






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






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






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






18. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






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






20. Used for - Initially populating the Metadata - Creating schema objects






21. The default entry-points.






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






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






24. To see data at completely different levels - other than that of the original Grid or Graph






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






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






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






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






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






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






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






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






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






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






35. Simple - Compound - Nested - Derived






36. Enables users to gather business insight through data analysis. It is a request for specific - formatted data from a data-warehouse.






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






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






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






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






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






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






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






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






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






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






47. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






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






49. Less storage - Simple SQL - Complex ETL






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