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. Combining 1 or more metric objects with 1 or more mathematical operations or constants. May include simple - nested or other compound metrics.






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






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






5. You can _____________ in the Architect Graphical Interface.






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






7. The default entry-points.






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






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






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






11. OnLine Analytical Processing - Organized by dimension and business subject - uses batch loaded - reporting - read-only - spiked usage (based on time of data-warehouse loading)






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






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






14. Formula - Level (Dimensionality) - Conditionality - Transformation






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






16. Facts - Attributes - Hierarchies






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






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






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






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






21. User management - Security profiles - Server parameters - like report length - idle time and report prioritization






22. Tables - Facts - Attributes - Hierarchies






23. A shortcut to an existing Object in a Project






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






25. Attribute Creation Wizard - Attribute Editor






26. More storage - Complex SQL - Simple ETL






27. OLAP retains data ________






28. User requirements - Existing source data - Technical and performance considerations






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






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






31. A user interface for creating and maintaining a BI environment






32. Columns - Tables






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






34. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






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






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






37. OLTP data storage measure






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






39. View Filters can only ___________.






40. Descriptive data that provides context for Facts.






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






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






43. Create the Project Source - Create the Database Instance






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






45. Allow you to interact with the BI system - logically organize data to analyze complex relationships






46. Using the Prompt Generation Wizard - Inside the Report Editor






47. All report-level options overwrite ___________.






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






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






50. Used to: - Create the Project - Select Project tables - Create basic Facts - Create basic Attributes and their relationships