Data Management Tasks DS0-001 Practice Questions (Page 1)

Questions 1–5

1. 1expert · hard

   A financial reporting system uses a materialized view to aggregate transactions by account. The view is refreshed every 15 minutes. A new requirement demands that reports reflect data within 1 minute of a transaction being posted. The base table is very large, and the aggregation query is expensive. What is the most appropriate solution?

   • AKeep the materialized view but change the refresh to be triggered by a database event when a new transaction is posted.
   • BIncrease the refresh frequency of the materialized view to every minute.
   • CReplace the materialized view with a standard view that queries the base table directly.
   • DCreate an index on the base table's transaction date column to speed up the aggregation query.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which type of relationship is established when a record in Table A can be associated with multiple records in Table B, but a record in Table B can be associated with only one record in Table A?

   • AOne-to-many
   • BSelf-referencing
   • COne-to-one
   • DMany-to-many
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A university database currently stores the department name and department head's name in the COURSES table. You are tasked with redesigning the schema to reduce data redundancy. Which approach best achieves this goal?

   • AKeep the department name in COURSES but remove the department head's name to save space.
   • BCreate a separate table for each department and store its courses in that table.
   • CAdd an index on the department name column in the COURSES table to speed up lookups.
   • DCreate a DEPARTMENTS table and replace the department name and head name in COURSES with a DepartmentID foreign key.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which of the following is a common benefit of using views?

   • AThey permanently store data to improve query speed
   • BThey reduce the need for database backups
   • CThey simplify complex queries by hiding joins and filters
   • DThey automatically replicate data to other servers
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   How does a materialized view differ from a standard view?

   • AA materialized view is automatically updated on every query
   • BA materialized view cannot be indexed
   • CA materialized view can only be created on a single table
   • DA materialized view stores the query results as a physical table
   Reveal Solution Discussion Select an answer first