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 detailed - graphical representation of the physical structure of a database. Usually based on a logical data model.






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






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






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






5. Columns - Tables






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






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






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






9. Folder List - Object Viewer - Shortcut Bar






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






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






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






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






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






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






16. Facts - Attributes - Hierarchies






17. A subset of a report that users can manipulate without altering the SQL


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






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






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






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






22. Store info on relationships between 2 or more tables (attributes) - like an Index table.






23. Store info about attributes - including IDs and any descriptions. Used for easier browsing.






24. The default entry-points.






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






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






27. Grid View - Graph View - Grid/Graph View - SQL View






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






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






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






31. Top menu/dropdowns - Toolbar - Right-click popup menus






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






33. All Attributes must have an _______.






34. ID columns - Description columns - Fact columns






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






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






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






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






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






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






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






42. SUM - AVG - Standard Deviation - Moving Average - Correlation - U-tiling






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






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






45. Tables that contain fact data and attribute ID columns that describe the level at which the fact values are recorded






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






47. Reduced number of JOINS in the generated SQL






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






49. It creates the System Hierarchy - when you define Attributes and their corresponding relationships






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