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. OLAP Services does not add any ______ to the report query.






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






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






4. OLAP data storage measure






5. OLTP data storage measure






6. The default entry-points.






7. More storage - Complex SQL - Simple ETL






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






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






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






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






12. Tables - Facts - Attributes - Hierarchies






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






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






15. It contains the ID and DESC columns of all higher-level attributes






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






17. Used to "fine-tune" your Project






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






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






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






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






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






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






24. Direct: A parent > child relationship - Indirect: 2 or more attributes are related only through a fact or set of facts






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






26. AND - OR - OR NOT - AND NOT






27. Source Systems - ETL Processes - Data-Warehouse - Metadata - MSTR Applications






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






29. View Filters are saved with the _____________.






30. Filter definition prompts - Object prompts - Value prompts - Level prompts






31. You can e-mail reports by going to _____






32. It contains the ID column of the parent attribute






33. Primary keys






34. Simple: 1 fact to 1 column - Derived: 1 fact to an expression that combines multiple facts to create a derived expression






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






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






37. Based on facts or attributes - Place at least 1 aggregation inside of another - Include 1 or more level definitions - May include 1 or more conditions - May include 1 or more transformations






38. Attribute Creation Wizard - Attribute Editor






39. Descriptive data that provides context for Facts.






40. Homogeneous - Heterogeneous






41. The Attribute Form maps to different column names in multiple tables






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






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






44. How users can share comments for reports to other users






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






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






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






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






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






50. Prompts to select filtering criteria from hierarchies - attributes - attribute element lists - and metrics.