CDL practice questions 111–120

1. Question 111 · 288 in bank

   An organization is running SQL Server on-premises and is struggling with capacity and management overhead. They want to modernize this database quickly by using Google products or services. What should the organization do?

   • ARefactor applications to use a cloud first database like Firestore.
   • BPerform a managed database migration to Cloud SQL.
   • CExport old tables from SQL Server to Cloud Storage.
   • DMigrate all SQL Server data to BigQuery.

   Show answer

   Answer: B

   Explanation

   B: Cloud SQL is Google Cloud's fully managed database service that supports SQL Server, among other databases like MySQL and PostgreSQL. By migrating to Cloud SQL, the organization can leverage a managed service that handles much of the database administration tasks such as patching, updates, and setup, thereby reducing management overhead. Cloud SQL also offers automatic scaling capabilities, addressing the concern about capacity that the organization is facing with their on-premise solution. Migrating to Cloud SQL would involve minimal changes to the existing applications since it supports SQL Server, allowing for a smoother transition without needing extensive application refactoring or redevelopment.

   Source: Adapted from community discussion — Vivek007

   Next question

2. Question 112 · 288 in bank

   Your organization needs a large amount of extra computing power within the next two weeks. After those two weeks, the need for the additional resources will end. Which is the most cost-effective approach?

   • AUse a committed use discount to reserve a very powerful virtual machine
   • BPurchase one very powerful physical computer
   • CStart a very powerful virtual machine without using a committed use discount
   • DPurchase multiple physical computers and scale workload across them

   Show answer

   Answer: C

   Explanation

   C is correct because we don’t know the compute use for 2 weeks and discount is available on 1-3 years not for 2 weeks. https://cloud.google.com/compute/docs/instances/signing-up-committed-use-discounts

   Source: Adapted from community discussion — Syd

   References

   • Google Cloud documentation
   • Google Cloud documentation

   Next question

3. Question 113 · 288 in bank

   Your organization is developing an application that will capture a large amount of data from millions of different sensor devices spread all around the world. Your organization needs a database that is suitable for worldwide, high-speed data storage of a large amount of unstructured data. Which Google Cloud product should your organization choose?

   • AFirestore
   • BCloud Data Fusion
   • CCloud SQL
   • DCloud Bigtable

   Show answer

   Answer: D

   Explanation

   For worldwide, high-speed data storage of a large amount of unstructured data captured from millions of sensor devices, the suitable Google Cloud product for your organization would be Cloud Bigtable. Cloud Bigtable is a fully managed, highly scalable, and high-performance NoSQL database service designed for large-scale applications that require low-latency and high-throughput data storage.

   Source: Adapted from community discussion — cookieMr

   References

   • Google Cloud documentation

   Next question

4. Question 114 · 288 in bank

   What is a benefit of the OpEx model for cloud security?

   • AOrganizations do not need to make upfront capital investments in cloud security.
   • BOrganizations can deploy custom security hardware.
   • COrganizations do not need to configure any security settings for cloud resources.
   • DThe cloud provider guarantees security.

   Show answer

   Answer: A

   Next question

5. Question 115 · 288 in bank

   What is the benefit of using a serverless data processing pipeline service?

   • AFull control over compute resources is provided.
   • BProcessed data will not require analysis.
   • CPipeline infrastructure is fully managed and scalable.
   • DProcessed data is guaranteed to be free of errors.

   Show answer

   Answer: C

   Explanation

   C: Managed and Scalable: The primary advantage of serverless data processing services is that they abstract the underlying infrastructure management away from the user. This means the cloud provider manages the scaling, maintenance, patching, and availability of the servers. The service automatically scales up or down based on the workload, which can significantly reduce operational complexity and cost.

   Source: Adapted from community discussion — Vivek007

   Next question

6. Question 116 · 288 in bank

   What does the shift toward cloud computing represent for an organization's transformation?

   • AAn opportunity that is limited to large enterprises
   • BAn opportunity to redefine existing business processes and services
   • CAn opportunity that is only relevant to the IT department
   • DAn opportunity to continue business as usual with new cost savings

   Show answer

   Answer: B

   Next question

7. Question 117 · 288 in bank

   An organization is concerned about the unlikely event that Google Cloud infrastructure is physically accessed by someone with malicious intent. How is data protected in Google Cloud?

   • AData is immediately deleted whenever an intrusion is detected.
   • BData is stored on quantum computers with unbreakable encryption.
   • CData is stored using robust encryption.
   • DData is stored in random locations around the world to prevent it being found.

   Show answer

   Answer: C

   Explanation

   C: Robust Encryption: Google Cloud uses multiple layers of encryption to protect data at rest and in transit. This means that even if someone were to physically access the hardware, the data stored would still

   Source: Adapted from community discussion — Vivek007

   Next question

8. Question 118 · 288 in bank

   An organization needs a flexible and scalable NoSQL database with strong web and mobile application support. Which Google Cloud product or service should the organization use?

   • ACloud Spanner
   • BCloud Storage
   • CBigQuery
   • DFirestore

   Show answer

   Answer: D

   Explanation

   D: Firestore (formerly known as Cloud Firestore) is a highly scalable, serverless, NoSQL document database built for automatic scaling, high performance, and ease of application development. It provides powerful querying and real-time data synchronization capabilities, making it ideal for web and mobile applications that require a responsive and dynamic user experience. Firestore also integrates well with other Firebase features, enhancing its suitability for developing web and mobile applications.

   Source: Adapted from community discussion — Vivek007

   Next question

9. Question 119 · 288 in bank

   An organization is using three cloud vendors to maximize their available deployment locations worldwide. They are using GKE Enterprise to deploy Kubernetes applications across different clouds. What type is this deployment?

   • AOn-premises
   • BMulti-cloud
   • CHybrid-cloud
   • DPrivate cloud

   Show answer

   Answer: B

   Explanation

   Hybrid Cloud: Combines on-premises or private cloud infrastructure with public cloud services. Multi-Cloud: Utilizes multiple public cloud providers without necessarily involving on-premises infrastructure.

   Source: Adapted from community discussion — AnkAro

   Next question

10. Question 120 · 288 in bank

    An organization wants to transfer some of its data from Google Cloud. Which of these statements is true?

    • ACustomer data may not be transferred out of Google Cloud.
    • BCustomers have full control of their data and may transfer it at any time.
    • COutgoing data transfer must be enabled in the Google Cloud console.
    • DA technical support ticket must be raised with the correct department.

    Show answer

    Answer: B

    Explanation

    B: Customer Data Control: One of the core principles of cloud services like Google Cloud is that customers retain ownership and control of their data. This means that customers can export or transfer their data whenever they need to, without any restrictions from the cloud provider. Google Cloud provides various tools and services that facilitate data export and transfer, supporting the organization's autonomy over their data.

    Source: Adapted from community discussion — Vivek007

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

CDL practice, question 111. 288 questions available.