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

Questions 11–15

1. 11foundation · easy

   Which report feature allows you to organize records into sections based on a common value?

   • AFiltering
   • BSorting
   • CFormatting
   • DGrouping
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   Which scaling approach involves adding more servers to distribute the database load?

   • AHorizontal scaling
   • BData compression
   • CVertical scaling
   • DDatabase indexing
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A warehouse manager wants a report that shows inventory levels for each product category. The manager wants to see the total number of items in each category and have the categories listed alphabetically. What report features should be used?

   • AFiltering to show only one category and sorting by item count
   • BGrouping by item name and sorting by category
   • CGrouping by category and sorting by category name
   • DNo grouping, just a simple list of all items
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A small business runs its inventory database on a single server that is now reaching its CPU and memory limits during peak hours. The business expects steady growth over the next few years and wants a solution that can handle increasing load without requiring a complete redesign of the application. What should the administrator do first?

   • AAdd more storage space to the server's hard drive
   • BUpgrade the existing server with more CPUs and RAM
   • CDelete all historical records from the database to reduce its size
   • DImmediately migrate the database to a distributed cluster with multiple servers
   Reveal Solution Discussion Select an answer first
6. 15application · easy

   A user needs to find the phone number of a specific client in a large customer database. The user knows the client's last name. What is the most efficient way to retrieve this single piece of information?

   • ADelete the customer table and recreate it with only the needed record
   • BScroll through the entire customer table row by row
   • CRun a query that selects the phone number field and filters records where the last name matches
   • DPrint the entire database and search the paper copy
   Reveal Solution Discussion Select an answer first