Question 1

A team is designing a pipeline to ingest large amounts of raw data from multiple external sources into BigQuery for further analysis. They plan to perform basic data transformations, such as removing duplicates and standardizing date formats, before loading the data. Which data manipulation methodology is most suitable for this scenario?

Options :

A : ELT (Extract, Load, Transform)

B : ETB (Extract, Transform, Backup)

C : ETLT (Extract, Transform, Load, Transform)

D : ETL (Extract, Transform, Load)

Answer: D

Question 2

Which encryption method should a company choose if it wants complete control over key rotation and deletion, while still using Cloud Storage?

Options :

A : Google-managed encryption keys (GMEK)

B : Cloud HSM (Hardware Security Module)

C : Customer-supplied encryption keys (CSEK)

D : Customer-managed encryption keys (CMEK)

Answer: D

Question 3

A company wants to migrate a large dataset of historical data from its on-premises storage to Cloud Storage. The dataset is around 100 TB, and the company has a limited network bandwidth, which would make online transfer highly time-consuming and resource-intensive. They need a solution that allows them to quickly and securely transfer this data to Google Cloud without causing disruptions to their ongoing operations. Which data transfer tool should the company choose?

Options :

A : Transfer Appliance

B : BigQuery Data Transfer Service

C : Cloud Data Fusion

D : Storage Transfer Service

Answer: A

Question 4

Which two advantages does using pretrained Google Large Language Models (LLMs) via a remote connection in BigQuery offer when working with natural language processing (NLP) tasks? (Select two)

Options :

A : Google LLMs enable the immediate use of sophisticated NLP capabilities without requiring model development or training expertise.

B : Google LLMs are primarily suited for numerical data processing, making them less ideal for NLP within BigQuery.

C : BigQuery provides built-in support for custom Python packages, allowing advanced NLP operations on Google LLMs directly.

D : Custom layers can be added to pretrained LLMs directly in BigQuery for domain-specific tuning.

E : Integration with BigQuery ML allows users to query and process large datasets using Google LLMs at scale.

Answer: A,E

Question 5

Your company stores critical financial data in Cloud Storage. To ensure both high availability and disaster recovery, you need to choose a suitable storage location strategy. The company requires immediate access to data with minimal latency and must comply with data redundancy best practices, ensuring that data is available even in the event of a regional outage. Which of the following options best meets these requirements?

Options :

A : Store data in a dual-region bucket without Turbo replication.

B : Store data in a dual-region bucket with Turbo replication.

C : Store data in a single-region bucket with versioning enabled.

D : Store data in a multi-region bucket in a continent far from the main office location.

Answer: B

Smartly Prepare Exam with Free Online Associate-Data-Practitioner Practice Test

Buying Options: