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. What tool do you use to create the Metadata DSN connection?






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






3. One that uses 2 or more columns as its ID






4. Folder List - Object Viewer - Shortcut Bar






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






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






7. OLTP retains data ________






8. Extraction - transformation - loading






9. Simple - Derived






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






11. Used to modify a Report






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






13. AND - OR - OR NOT - AND NOT






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






15. Attribute Creation Wizard - Attribute Editor






16. The Attribute Form Expression that maps to a single column - no matter the number of tables






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






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






19. Subtotals reflect accumulations at selected attribute levels






20. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






21. Less storage - Simple SQL - Complex ETL






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






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






24. 1 - List info from the data source 2 - Identify facts 3 - Identify attributes 4 - Determine direct attribute relationships 5 - Organize hierarchies






25. Create the Project Source - Create the Database Instance






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






27. A condition data must meet in order to be included in a report. Does affect the SQL.






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






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






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






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






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






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






34. Grid View - Graph View - Grid/Graph View - SQL View






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






36. Prompts to select objects to include in a report - such as attributes - metrics - custom groups - template objects - report filter objects - etc.






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






38. How users can share comments for reports to other users






39. Specifies a condition data must meet in order to be included in a report






40. Represent business performance. Typically numeric. Must be aggregated to produce a meaningful result. Are directly linked to columns in the data-warehouse.






41. The unique values of an attribute obtained from the data-warehouse






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






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






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






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






46. Must have Subtotals enabled - or you won't see any data for higher-level attributes






47. All report-level options overwrite ___________.






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






49. Used to "fine-tune" your Project






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