You are designing a Node.js-based mobile news feed application that stores data on Google Cloud. You need to select the application's database. You want the database to have zonal resiliency out of the box, low latency responses, ACID compliance, an optional middle tier, semi-structured data storage, and network-partition-tolerant and offline-mode client libraries. What should you do?

A. Configure Firestore and use the Firestore client library in the app. B. Configure Bigtable and use the Bigtable client in the app. C. Configure Cloud SQL and use the Google Client Library for Cloud SQL in the app. D. Configure BigQuery and use the BigQuery REST API in the app.