[2026] Google Cloud Associate Data Practitioner - Associate-Data-Practitioner 무료 시험 문제

문제1

Your organization has a BigQuery dataset that contains sensitive employee information such as salaries and performance reviews. The payroll specialist in the HR department needs to have continuous access to aggregated performance data, but they do not need continuous access to other sensitive data. You need to grant the payroll specialist access to the performance data without granting them access to the entire dataset using the simplest and most secure approach. What should you do?

A. Use authorized views to share query results with the payroll specialist.

B. Create a table with the aggregated performance data. Use table-level permissions to grant access to the payroll specialist.

C. Create a SQL query with the aggregated performance data. Export the results to an Avro file in a Cloud Storage bucket. Share the bucket with the payroll specialist.

D. Create row-level and column-level permissions and policies on the table that contains performance data in the dataset. Provide the payroll specialist with the appropriate permission set.

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제2

Your organization is conducting analysis on regional sales metrics. Data from each regional sales team is stored as separate tables in BigQuery and updated monthly. You need to create a solution that identifies the top three regions with the highest monthly sales for the next three months. You want the solution to automatically provide up-to-date results. What should you do?

A. Create a BigQuery materialized view that performs a union across all of the regional sales tables. Use the rank() window function to query the new materialized view.

B. Create a BigQuery materialized view that performs a cross join across all of the regional sales tables.Use the row_number() window function to query the new materialized view.

C. Create a BigQuery table that performs a union across all of the regional sales tables. Use the row_number() window function to query the new table.

D. Create a BigQuery table that performs a cross join across all of the regional sales tables. Use the rank() window function to query the new table.

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제3

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 data. You need to migrate this data while maintaining data integrity, and minimizing downtime and cost. What should you do?

A. 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.

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

C. 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.

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

정답: D

설명: (Fast2test 회원만 볼 수 있음)

문제4

You work for a global financial services company that trades stocks 24/7. You have a Cloud SGL for PostgreSQL user database. You need to identify a solution that ensures that the database is continuously operational, minimizes downtime, and will not lose any data in the event of a zonal outage. What should you do?

A. Create a read replica in the same region but in a different zone.

B. Create a read replica in another region. Promote the replica to primary if a failure occurs.

C. Configure and create a high-availability Cloud SQL instance with the primary instance in zone A and a secondary instance in any zone other than zone A.

D. Continuously back up the Cloud SGL instance to Cloud Storage. Create a Compute Engine instance with PostgreSCL in a different region. Restore the backup in the Compute Engine instance if a failure occurs.

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제5

You are designing an application that will interact with several BigQuery datasets. You need to grant the application's service account permissions that allow it to query and update tables within the datasets, and list all datasets in a project within your application. You want to follow the principle of least privilege. Which pre- defined IAM role(s) should you apply to the service account?

A. roles/bigquery.user and roles/bigquery.filteredDataViewer

B. roles/bigquery.admin

C. roles/bigquery.jobUser and roles/bigquery.dataOwner

D. roles/bigquery.connectionUser and roles/bigquery.dataViewer

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제6

You are designing a pipeline to process data files that arrive in Cloud Storage by 3:00 am each day. Data processing is performed in stages, where the output of one stage becomes the input of the next. Each stage takes a long time to run. Occasionally a stage fails, and you have to address the problem. You need to ensure that the final output is generated as quickly as possible. What should you do?

A. Design the processing as a directed acyclic graph (DAG) in Cloud Composer. Clear the state of the failed task after correcting any stage output data errors.

B. Design the pipeline as a set of PTransforms in Dataflow. Restart the pipeline after correcting any stage output data errors.

C. Design a Spark program that runs under Dataproc. Code the program to wait for user input when an error is detected. Rerun the last action after correcting any stage output data errors.

D. Design the workflow as a Cloud Workflow instance. Code the workflow to jump to a given stage based on an input parameter. Rerun the workflow after correcting any stage output data errors.

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제7

You are a data analyst working with sensitive customer data in BigQuery. You need to ensure that only authorized personnel within your organization can query this data, while following the principle of least privilege. What should you do?

A. Enable access control by using IAM roles.

B. Export the data to Cloud Storage, and use signed URLs to authorize access.

C. Update dataset privileges by using the SQL GRANT statement.

D. Encrypt the data by using customer-managed encryption keys (CMEK).

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제8

Your organization has several datasets in BigQuery. The datasets need to be shared with your external partners so that they can run SQL queries without needing to copy the data to their own projects. You have organized each partner's data in its own BigQuery dataset. Each partner should be able to access only their data. You want to share the data while following Google-recommended practices. What should you do?

A. Create a Dataflow job that reads from each BigQuery dataset and pushes the data into a dedicated Pub
/Sub topic for each partner. Grant each partner the pubsub. subscriber IAM role.

B. Use Analytics Hub to create a listing on a private data exchange for each partner dataset. Allow each partner to subscribe to their respective listings.

C. Grant the partners the bigquery.user IAM role on the BigQuery project.

D. Export the BigQuery data to a Cloud Storage bucket. Grant the partners the storage.objectUser IAM role on the bucket.

정답: B

설명: (Fast2test 회원만 볼 수 있음)

Google Cloud Associate Data Practitioner - Associate-Data-Practitioner무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트