Question 1

You are migrating data from a legacy on-premises MySQL database to Google Cloud. The database contains various tables with different data types and sizes, including large tables with millions of rows and transactional dat a. You need to migrate this data while maintaining data integrity, and minimizing downtime and cost. What should you do?

Options :

A :

Set up a Cloud Composer environment to orchestrate a custom data pipeline. Use a Python script to extract data from the MySQL database and load it to MySQL on Compute Engine.

B :

Export the MySQL database to CSV files, transfer the files to Cloud Storage by using Storage Transfer Service, and load the files into a Cloud SQL for MySQL instance.

C :

Use Database Migration Service to replicate the MySQL database to a Cloud SQL for MySQL instance.

D : Use Cloud Data Fusion to migrate the MySQL database to MySQL on Compute Engine.

Answer: C

Question 2

Your organization is assessing its data security requirements on Google Cloud. Which of the following statements accurately describes encryption at rest and its purpose?

Options :

A : Encryption at rest protects data during storage and ensures it cannot be accessed if a device is physically removed or stolen.

B : Encryption at rest uses only asymmetric encryption algorithms for all Google Cloud storage services.

C : Encryption at rest ensures that data is protected from unauthorized access during network transfers to other Google Cloud services.

D : Encryption at rest only encrypts data on databases, while encryption in transit protects data stored on all other storage types.

Answer: A

Question 3

You are working for an e-commerce company that wants to monitor the real-time performance of sales across various categories. They require a dashboard that displays both the overall sales and category-specific sales data for the current day, with a goal of quickly identifying which categories are underperforming. Which Looker feature should you use to fulfill these requirements?

Options :

A : Use the Table visualization type and add a calculated field that updates automatically based on daily sales data.

B : Develop a LookML model that aggregates sales data on a monthly basis, then filter for current day data within the dashboard.

C : Implement a dashboard filter that allows users to toggle between categories and the overall sales data.

D : Set up a series of visualizations using the Single Value visualization type to show category-specific and overall sales on the same dashboard.

Answer: D

Question 4

A data team is using Google Cloud to process a large dataset with inconsistent date formats, empty strings, and incorrectly capitalized text values. They want to standardize these formats, remove empty strings, and apply other basic data-cleaning operations. Which service should they use to process this data efficiently using SQL-like queries?

Options :

A : Cloud Datastore

B : Firebase Realtime Database

C : Cloud Dataflow

D : BigQuery

Answer: D

Question 5

Your organization plans to move their on-premises environment to Google Cloud. Your organizations network bandwidth is less than 1 Gbps. You need to move over 500 Ð¢Ð’ of data to Cloud Storage securely, and only have a few days to move the dat a. What should you do?

Options :

A :

Request multiple Transfer Appliances, copy the data to the appliances, and ship the appliances back to Google Cloud to upload the data to Cloud Storage.

B :

Connect to Google Cloud using VPN. Use Storage Transfer Service to move the data to Cloud Storage.

C :

Connect to Google Cloud using VPN. Use the gcloud storage command to move the data to Cloud Storage.

D :

Connect to Google Cloud using Dedicated Interconnect. Use the gcloud storage command to move the data to Cloud Storage.

Answer: A

Higher Test Marks with Free Online Associate-Data-Practitioner Exam Practice

Buying Options: