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

Questions 1–5

1. 1application · medium

   A school administrator needs to provide a printed document to the principal showing the average grade for each class, sorted by class name. The data is in a database. What should the administrator create?

   • AA query that deletes all grades below the average
   • BA backup of the database to a USB drive
   • CA report that groups by class, calculates the average grade, and sorts by class name
   • DA new table that manually lists each class and its average
   Reveal Solution Discussion Select an answer first
2. 2expert · hard

   A rapidly growing social media platform's database is struggling with a surge in read requests. The current single, powerful server has reached the maximum amount of RAM and CPU that its hardware supports. The company cannot afford any downtime and needs to handle more concurrent users. Which approach is the most appropriate next step?

   • AUpgrade the server's network card to a faster model
   • BReduce the database's storage capacity to free up memory
   • CSwitch to a slower, more reliable database engine
   • DImplement horizontal scaling by adding more servers to distribute the read load
   Reveal Solution Discussion Select an answer first
4. 3expert · hard

   A startup with unpredictable traffic patterns needs a customer database. The database will experience very low usage for most of the year but will have massive spikes during a two-week sales event. The startup has no IT staff and wants to avoid paying for idle resources. Which approach is most appropriate?

   • AAn on-premises database sized for the peak traffic
   • BA local database on a single workstation
   • CA cloud database service that can automatically scale resources up and down based on demand
   • DA cloud database with a fixed, large capacity that never changes
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A manager wants a sales report that lists each salesperson's total sales, with the salespeople sorted from highest to lowest total. The report should also show a grand total at the end. What report features are needed?

   • AGrouping by product category and sorting by date
   • BGrouping by salesperson, sorting by total in descending order, and adding a summary section
   • CFiltering to show only the top salesperson and no summary
   • DSorting by salesperson name alphabetically and adding a header
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   What is the primary purpose of a database report?

   • ATo present data in a formatted, readable format for analysis or sharing
   • BTo automatically back up the database
   • CTo enforce data integrity rules
   • DTo store raw data in a structured format
   Reveal Solution Discussion Select an answer first