Maintenance Processes DS0-001 Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   What is the primary purpose of applying database patches?

   • ATo add new features and improve performance
   • BTo change the database's default port
   • CTo increase the database's maximum storage capacity
   • DTo fix security vulnerabilities and bugs
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which of the following is an example of allocating database resources effectively?

   • ASetting the database to use only one CPU core
   • BAssigning more memory to the database buffer pool
   • CRemoving all indexes to free up storage
   • DDisabling the database's query optimizer
   Reveal Solution Discussion Select an answer first
4. 13expert · medium

   A company's database is growing at 15% per year. The current storage is 1 TB and is 70% full. The company is planning a major marketing campaign that is expected to double the transaction volume for six months. The budget is limited, and the company wants to avoid over-provisioning storage. What is the most balanced capacity planning approach?

   • ADo not purchase any new storage and rely on the current 30% free space.
   • BMigrate the database to a cloud service with auto-scaling storage.
   • CPurchase storage to cover the campaign period and the normal growth rate for the next year, then monitor and adjust.
   • DImmediately purchase enough storage to cover the projected growth for the next five years.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   What information does a query execution plan provide?

   • AThe database's version history
   • BThe steps the database will take to execute the query
   • CThe list of all users currently connected to the database
   • DThe database's backup schedule
   Reveal Solution Discussion Select an answer first
6. 15expert · medium

   A database administrator is analyzing an execution plan for a query that joins two large tables. The optimizer has chosen a hash join. The query is slow, and the administrator notices that the estimated number of rows for one of the tables is significantly lower than the actual number of rows. What is the most likely cause of the poor performance?

   • AThe query is missing a WHERE clause.
   • BThe tables are not indexed on the join columns.
   • CThe hash join is the wrong join type for this query.
   • DThe statistics for the table are outdated, causing the optimizer to choose a suboptimal plan.
   Reveal Solution Discussion Select an answer first