Question 1

A company stores large amounts of data in Cloud Storage that is only accessed a few times a year for quarterly reports. The data needs to be retained for a minimum of three years for compliance purposes, but retrieval speed is not critical. Which storage class is the most cost-effective option?

Options :

A : Nearline

B : Archive

C : Coldline

D : Standard

Answer: C

Question 2

Which of the following correctly describes the ETLT (Extract, Transform, Load, Transform) data processing methodology, and why it may be beneficial in modern data architectures?

Options :

A : ETLT involves loading raw data into a staging area, where transformation and loading processes occur simultaneously for real-time data integration.

B : ETLT performs all transformations outside the target system, allowing for increased data quality checks before loading into the target data warehouse.

C : ETLT is only used in cases where data is transformed in-memory without staging, maximizing processing speed for large datasets.

D : ETLT is a method where initial data cleaning and transformation happen after loading data into the target data warehouse, allowing a final transformation layer to refine and standardize data for analytics.

Answer: D

Question 3

A company is migrating its data storage to Google Cloud and needs to ensure data security for compliance with regulations. The company wants to understand the difference between encryption in transit and encryption at rest. Which of the following statements accurately describes encryption in transit?

Options :

A : Encryption in transit uses symmetric key encryption exclusively for data protection.

B : Encryption in transit secures data on physical storage devices, preventing unauthorized access if the hardware is stolen.

C : Encryption in transit only applies to data being transferred to and from on-premises systems, not within Google Cloud.

D : Encryption in transit protects data while it moves between Google Cloud services and prevents unauthorized access during data transfers.

Answer: D

Question 4

A retail company is using a variety of SaaS applications, including Google Ads and Salesforce, to collect and manage customer data. They want to extract data from these applications and load it directly into BigQuery on a daily basis for analytics purposes. The data must be automatically updated without manual intervention. Which Google Cloud service would best suit this requirement?

Options :

A : BigQuery Data Transfer Service

B : Cloud Dataflow

C : Database Migration Service

D : Cloud Data Fusion

Answer: A

Question 5

A healthcare organization needs to integrate data from various sources, including patient management systems, IoT devices, and electronic health records (EHRs). They want to process this data for immediate insights as well as store it in a structured data warehouse for long-term analysis. Given the sensitivity of the data and the need to perform some transformations on raw data, which of the following data processing approaches would be most suitable for this scenario?

Options :

A : Real-Time Streaming with ELT

B : ETL (Extract, Transform, Load)

C : Batch Processing with ELT

D : ELT (Extract, Load, Transform)

Answer: B

Free Associate-Data-Practitioner Mock Exam – Practice Online Confidently

Buying Options: