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. A simplified version of Desktop - providing interactive "slice-&-dice" capabilities






2. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






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






4. All report-level options overwrite ___________.






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






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






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






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






9. Enables you to further narrow down a report view - using only those objects in the report without altering the SQL of the report query. They are executed after-the-fact.






10. Compound - Homogeneous - Heterogeneous






11. A detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






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






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






15. AND - OR - OR NOT - AND NOT






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






17. History folder: To retrieve scheduled reports - MyPersonal Objects: Objects you create - visible only to you - Public Objects: Objects that can be viewed by all - Schema Objects: Objects that represent the logical data model (facts - attributes and h






18. Columns - Tables






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. 1 - Quick Sort: Only accessible from Grid view 2 - Advanced Sort: Available in Grid or Graph views






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






22. Grid View - Graph View - Grid/Graph View - SQL View






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






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






25. Direct: 2-tier - Server: 3-tier






26. Graph Properties - accessible under Top Menu > Graph > Preferences from Graph View






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






28. Metrics aggregate on the lowest-level attribute __________.






29. To define the level of aggregation for a specific metric - Used for qualifications






30. The default entry-points.






31. It contains the ID column of the parent attribute






32. To change the display of a report - including alignments - fonts - borders and backgrounds. You can format report headers - values or both.






33. Include 1 or more aggregate functions - Based on 1 or more facts or attributes - Include a specified level at which they are calculated - May include conditions - May include transformations






34. Groupings of directly related attributes. Also commonly known as "dimensions".






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






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






37. Enables you to search for a specific Object or group of Objects that meet a certain criteria.






38. View Filters are saved with the _____________.






39. A shortcut to an existing Object in a Project






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






41. A connection to the Metadata database. It's also the highest icon in the folder list window of Desktop.






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






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






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






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






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






47. Less storage - Simple SQL - Complex ETL






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






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






50. All Attributes must have an _______.