Database Use: Queries, Reports, Scalability, Cloud vs. Local Storage. IT-FUNDAMENTALS-ITF-CERTIFICATION Practice Questions (Page 7)

Questions 31–35

1. 31foundation · easy

   Which of the following is a benefit of cloud-based database storage?

   • AGuaranteed zero downtime
   • BAccessibility from anywhere with an internet connection
   • CNo need for internet connectivity
   • DData is always stored on the user's local hard drive
   Reveal Solution Discussion Select an answer first
2. 32foundation · easy

   Which type of query is used to add, update, or delete records in a database?

   • AParameter query
   • BAction query
   • CSelect query
   • DCross-tab query
   Reveal Solution Discussion Select an answer first
4. 33application · medium

   A non-technical executive requests a monthly summary of sales by region, formatted with totals and subtotals, to present at a board meeting. The data resides in a relational database. What is the most efficient way for the database administrator to provide this?

   • ARun a DELETE query to remove all but the summary rows from the sales table
   • BSend the executive a direct link to the raw database table so they can browse the data
   • CCreate a report that runs a query to aggregate sales by region and includes grouping and summary sections
   • DExport the entire sales table to a spreadsheet and manually calculate totals each month
   Reveal Solution Discussion Select an answer first
5. 34application · medium

   A company is deciding between a cloud database and an on-premises database. The company has strict data residency requirements, meaning all data must remain within a specific country. The company also has a limited IT staff. Which factor is most important in this decision?

   • AThe number of employees in the company
   • BThe color scheme of the database management software's interface
   • CThe brand of the servers used for on-premises storage
   • DWhether the cloud provider offers a data center region within the required country
   Reveal Solution Discussion Select an answer first
6. 35expert · hard

   An online gaming company's database is experiencing slowdowns during peak evening hours. The database runs on a single server that has available storage space but is using 95% of its CPU. The company needs a quick fix to improve performance immediately. What is the most appropriate immediate action?

   • AAdd more storage space to the server
   • BMigrate the database to a new server in a different country
   • CAdd more CPU cores to the existing server
   • DDisable all database indexes to reduce overhead
   Reveal Solution Discussion Select an answer first