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. Design View - Grid View - Graph View - Grid/Graph VIew - SQL View






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






3. Enables you to format report values based on a condition - such as highlights - font colors - etc.






4. Define the analytical calculations to perform on the data-warehouse. Made up of Facts.






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






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






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






8. ID columns - Description columns - Fact columns






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






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






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






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






13. All Attributes must have an _______.






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






15. Create an empty Metadata database - Create the Metadata DSN connection - Create the Metadata shell






16. Normalized: No data redundancy - Moderately Denormalized: Some data redundancy with shared Table Keys - Completely Denormalized: Lots of data redundancy with shared Table Keys and description columns






17. Primary keys






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






19. Objects that map directly back to the data-warehouse. Can be used directly or used to build objects pulled onto reports






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






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






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






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






24. Contains info that facilitates the transfer of data from the source systems to the data-warehouse






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






26. More storage - Complex SQL - Simple ETL






27. If you need to ____________ based on a specific Attribute Form - that form should be its own attribute.






28. All report-level options overwrite ___________.






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






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






31. Reduced number of JOINS in the generated SQL






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






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






34. OLTP retains data ________






35. Simple - Derived






36. View Filters can only ___________.






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






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






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






40. OLAP retains data ________






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






42. Level of OLAP integration






43. Simple - Nested - Compound - Numeric Constants - Simple metrics with levels - conditions or transformations as part of their definition






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






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






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






47. Metrics you create within a report using only those objects in the report.






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






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






50. You can save your auto-style from the Top Menu > Grid > Save AutoStyle As...