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. Level of OLAP integration






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






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






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






5. Subtotals reflect accumulations at selected attribute levels






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






7. Facts associated to different column names in 2 or more tables






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






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






10. OnLine Transaction Processing - Organized by workflow per application - uses real-time - write and update - evenly distributed transactional data






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






12. ID columns - Description columns - Fact columns






13. OLTP data storage measure






14. Template - Filter - View of a Report






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






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






17. Primary keys






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






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






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






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






22. Folder List - Object Viewer - Shortcut Bar






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






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






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






26. Simple - Compound - Nested - Derived






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






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






29. The System Hierarchy is automatically updated whenever you make a change to an __________________.






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






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






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






33. Display: On a report or in Data Explorer - Sorting: Sort report data using attribute forms - Qualifications: To filter on the elements of any attribute form






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






35. Level of OLTP integration






36. View Filters are saved with the _____________.






37. Schema Objects - Application Objects - Configuration Objects






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






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






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






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






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






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






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






45. Reduced number of JOINS in the generated SQL






46. Compound - Homogeneous - Heterogeneous






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






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






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






50. More storage - Complex SQL - Simple ETL







Sorry!:) No result found.

Can you answer 50 questions in 15 minutes?


Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests