Online Access Free Associate-Data-Practitioner Exam Questions

Your company uses Looker as its primary business intelligence platform. You want to use LookML to visualize the profit margin for each of your company's products in your Looker Explores and dashboards.
You need to implement a solution quickly and efficiently. What should you do?

• A.Create a new dimension that categorizes products based on their profit margin ranges (e.g., high, medium, low).
• B.Define a new measure that calculates the profit margin by using the existing revenue and cost fields.
• C.Create a derived table that pre-calculates the profit margin for each product, and include it in the Looker model.
• D.Apply a filter to only show products with a positive profit margin.

You work for a financial organization that stores transaction data in BigQuery. Your organization has a regulatory requirement to retain data for a minimum of seven years for auditing purposes. You need to ensure that the data is retained for seven years using an efficient and cost-optimized approach. What should you do?

• A.Export the BigQuery tables to Cloud Storage daily, and enforce a lifecycle management policy that has a seven-year retention rule.
• B.Create a partition by transaction date, and set the partition expiration policy to seven years.
• C.Set the dataset-level retention policy in BigQuery to seven years.
• D.Set the table-level retention policy in BigQuery to seven years.

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.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.
• B.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.Create a read replica in another region. Promote the replica to primary if a failure occurs.
• D.Create a read replica in the same region but in a different zone.

Your team uses Google Sheets to track budget data that is updated daily. The team wants to compare budget data against actual cost data, which is stored in a BigQuery table. You need to create a solution that calculates the difference between each day's budget and actual costs. You want to ensure that your team has access to daily-updated results in Google Sheets. What should you do?

• A.Create a BigQuery external table by using the Drive URI of the Google sheet, and join the actual cost table with it. Save the joined table, and open it by using Connected Sheets.
• B.Download the budget data as a CSV file, and upload the CSV file to create a new BigQuery table. Join the actual cost table with the new BigQuery table, and save the results as a CSV file. Open the CSV file in Google Sheets.
• C.Download the budget data as a CSV file and upload the CSV file to a Cloud Storage bucket. Create a new BigQuery table from Cloud Storage, and join the actual cost table with it. Open the joined BigQuery table by using Connected Sheets.
• D.Create a BigQuery external table by using the Drive URI of the Google sheet, and join the actual cost table with it. Save the joined table as a CSV file and open the file in Google Sheets.

Your organization is building a new application on Google Cloud. Several data files will need to be stored in Cloud Storage. Your organization has approved only two specific cloud regions where these data files can reside. You need to determine a Cloud Storage bucket strategy that includes automated high availability.
What should you do?

• A.Create a single-region bucket in each of the two regions, and use Storage Transfer Service to replicate the data across the buckets in both regions.
• B.Create a multi-region bucket, and upload the files to this bucket.
• C.Create a single-region bucket in each of the two regions, and use the gcloud storage command to replicate the data across the buckets in both regions.
• D.Create a dual-region bucket, and upload the files to this bucket.