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. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






2. Tables - Facts - Attributes - Hierarchies






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






4. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






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






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






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






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






9. OLAP Services does not add any ______ to the report query.






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






11. Folder List - Object Viewer - Shortcut Bar






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






13. Extraction - transformation - loading






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






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






16. Simple - Derived






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






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






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






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






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






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






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






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






25. Cannot be directly put onto a Report - must be aggregated in a Metric - which can be added to a Report






26. Compound - Homogeneous - Heterogeneous






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






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






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






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






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






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






33. Level of OLTP integration






34. Simple - Compound - Nested - Derived






35. You can _____________ in the Architect Graphical Interface.






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






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






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






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






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






41. Design the logical data model - Design the data-warehouse schema - Create the project in Architect - Manage the project schema






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






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






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






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






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






47. Facts - Attributes - Hierarchies






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






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






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