ADP 試験問題を無料オンラインアクセス

You are working with a large dataset of customer reviews stored in Cloud Storage. The dataset contains several inconsistencies, such as missing values, incorrect data types, and duplicate entries. You need toclean the data to ensure that it is accurate and consistent before using it for analysis. What should you do?

• A.Use BigQuery to batch load the data into BigQuery. Use SQL for cleaning and analysis.
• B.Use Cloud Run functions to clean the data and load it into BigQuery. Use SQL for analysis.
• C.Use the PythonOperator in Cloud Composer to clean the data and load it into BigQuery. Use SQL for analysis.
• D.Use Storage Transfer Service to move the data to a different Cloud Storage bucket. Use event triggers to invoke Cloud Run functions to load the data into BigQuery. Use SQL for analysis.

Your organization uses scheduled queries to perform transformations on data stored in BigQuery. You discover that one of your scheduled queries has failed. You need to troubleshoot the issue as quickly as possible. What should you do?

• A.Request access from your admin to the BigQuery information_schema. Query the jobs view with the failed job ID, and analyze error details.
• B.Navigate to the Scheduled queries page in the Google Cloud console. Select the failed job, and analyze the error details.
• C.Set up a log sink using the gcloud CLI to export BigQuery audit logs to BigQuery. Query those logs to identify the error associated with the failed job I
• D.Navigate to the Logs Explorer page in Cloud Logging. Use filters to find the failed job, and analyze the error details.

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 dat a. You want to share the data while following Google-recommended practices. What should you do?

• A.Grant the partners the bigquery.user IAM role on the BigQuery project.
• 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.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.
• D.Export the BigQuery data to a Cloud Storage bucket. Grant the partners the storage.objectUser IAM role on the bucket.

You created a customer support application that sends several forms of data to Google Cloud. Your application is sending:
1. Audio files from phone interactions with support agents that will be accessed during trainings.
2. CSV files of users' personally identifiable information (PII) that will be analyzed with SQL.
3. A large volume of small document files that will power other applications.
You need to select the appropriate tool for each data type given the required use case, while following Google- recommended practices. Which should you choose?

• A.Cloud Storage BigQuery Firestore
• B.Cloud Storage CloudSQL for PostgreSQL Bigtable
• C.Filestore Cloud SQL for PostgreSQL Datastore
• D.Filestore Bigtable BigQuery

You have created a LookML model and dashboard that shows daily sales metrics for five regional managers to use. You want to ensure that the regional managers can only see sales metrics specific to their region. You need an easy-to-implement solution. What should you do?

• A.Create five different Explores with thesql_always_filterExplore filter applied on theregion_namedimension. Set eachregion_namevalue to the corresponding region for each manager.
• B.Create asales_regionuser attribute, and assign each manager's region as the value of their user attribute.
• C.Create separate Looker dashboards for each regional manager. Set the default dashboard filter to the corresponding region for each manager.
• D.Add anaccess_filterExplore filter on theregion_namedimension by using thesales_regionuser attribute.