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. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






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






3. AND - OR - OR NOT - AND NOT






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






5. Enables you to rearrange the columns and rows in a report.






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






7. OLAP data storage measure






8. The logical associations between attributes that exist based on a business rule






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






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






11. Facts - Attributes - Hierarchies






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






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






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






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






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






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






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






19. It contains the ID column of the parent attribute






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






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






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






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






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






25. View Filters are saved with the _____________.






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






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






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






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






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






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






32. Tables - Facts - Attributes - Hierarchies






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






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






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






36. OLTP retains data ________






37. The Attribute Form maps to the same column name in multiple tables






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






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






40. Subtotals reflect accumulations at selected attribute levels






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






42. Creating multiple attributes quickly. Used during the initial project creation.






43. Simple - Compound - Nested - Derived






44. roject Creation Assistant - Schema Object Editor - Architect Graphical Interface






45. Descriptive data that provides context for Facts.






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






47. Enables you to select which tables from the data-warehouse to store in the Metadata database






48. Compound - Homogeneous - Heterogeneous






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






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