Support Testing and Security GH-300 Practice Questions (Page 4)

Questions 16–20

1. 16application · medium

   A developer is using Copilot to optimize a function that repeatedly queries a database for the same data within a single request. The data does not change during the request. What optimization should Copilot suggest?

   • AUse a stored procedure for the query
   • BIncrease the database connection pool size
   • CUse a database index on the queried column
   • DCache the query result and reuse it within the request
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   A developer notices that a function repeatedly queries the same data from a database inside a loop. What performance optimization should GitHub Copilot suggest?

   • AIncrease the loop's iteration count
   • BUse a slower database connection
   • CAdd more comments to the loop
   • DMove the query outside the loop and reuse the result
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   A developer asks GitHub Copilot to review a code snippet that constructs a SQL query by concatenating user input. What security improvement should Copilot suggest?

   • AIncrease the length of the user input
   • BAdd more comments to the code
   • CUse parameterized queries or prepared statements
   • DUse a different database
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A developer is using Copilot to review a function that processes a large list of customer records. The function currently uses a nested loop to find matching records, resulting in O(n²) time complexity. Which optimization should Copilot suggest?

   • AUse a more efficient sorting algorithm
   • BSort the list first and then use binary search for lookups
   • CUse a hash map to store records for O(1) lookups, reducing the overall complexity to O(n)
   • DBreak out of the inner loop early when a match is found
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A team is building an integration test for a service that publishes a message to a message queue and then processes the message in a separate consumer. Using Copilot, what is the most appropriate way to verify the interaction?

   • AMock the message queue and assert that the producer sends the correct message
   • BTest the producer and consumer separately with unit tests
   • CUse a test double for the consumer and assert the producer's message format
   • DUse a real message queue in a test environment and assert that the consumer processes the message correctly
   Reveal Solution Discussion Select an answer first