Database Fundamentals CV0-004 Practice Questions (Page 5)

Questions 21–25

1. 21application · medium

   A gaming company runs a database that experiences heavy write loads during new game launches but low traffic otherwise. They want to scale the database to handle the spikes without paying for idle capacity during quiet periods. Which scaling approach best meets this need?

   • AManual scaling by an administrator when needed
   • BVertical scaling by upgrading to a larger instance permanently
   • CHorizontal scaling with a fixed number of read replicas
   • DElastic scaling that automatically adds and removes resources based on load
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   Which of the following is a best practice for securing a cloud database?

   • ADisabling encryption to reduce latency
   • BGranting all users full administrative access for convenience
   • CPlacing the database on a public network for easy access
   • DUsing strong authentication and encrypting data in transit and at rest
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A company's database administrator wants to ensure that only authorized applications can access the cloud database, and that access is logged for security reviews. Which security measure should they implement?

   • AEnable encryption at rest for the database
   • BCreate individual database users for each application and enable auditing
   • CConfigure network security groups to allow only specific application IPs
   • DUse a shared database account for all applications
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   Which data storage model is best suited for storing data that is highly interconnected, such as social network relationships?

   • ADocument model
   • BRelational model
   • CKey-value model
   • DGraph model
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   Which data storage model stores data in tables with rows and columns and enforces a fixed schema?

   • AKey-value model
   • BGraph model
   • CDocument model
   • DRelational model
   Reveal Solution Discussion Select an answer first