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. Creating multiple attributes quickly. Used during the initial project creation.






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






3. Create the Project Source - Create the Database Instance






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






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






6. OLAP data storage measure






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






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






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






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






11. Formula - Level (Dimensionality) - Conditionality - Transformation






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






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






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






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






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






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






18. A shortcut to an existing Object in a Project






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






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






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






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






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






24. The default entry-points.






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






26. OLTP data storage measure






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






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






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






30. User reporting requirements - Query performance - Data volume - DB Maintenance






31. Enables you to lock column headers so that they always appear when scrolling






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






33. OLAP retains data ________






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






35. Less storage - Simple SQL - Complex ETL






36. Data is read/write - Data is assigned by application - Data formatting may not be uniform - Data may be limited to recent/current data






37. Used to modify a Report






38. Facts - Attributes - Hierarchies






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






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






41. Simple - Compound - Nested - Derived






42. The actual column name for a fact. Every fact must have at least 1 expression.






43. ID columns - Description columns - Fact columns






44. Level of OLAP integration






45. Schema Objects - Application Objects - Configuration Objects






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






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






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






49. Attributes - Metrics - Hierachies - Consolidations - Custom Groups - Object Prompts






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