Associate-Data-Practitioner Exam: Absolutely Free Online Practice

Question 1
- 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 dat a. You need to migrate this data while maintaining data integrity, and minimizing downtime and cost. What should you do?
  
  A :
  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.
  
  B :
  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.
  
  C :
  Use Database Migration Service to replicate the MySQL database to a Cloud SQL for MySQL instance.
  
  D : Use Cloud Data Fusion to migrate the MySQL database to MySQL on Compute Engine.
  
  Answer: C
Question 2
- A company wants to process customer purchase data in near real-time to update their analytics dashboard. The data should go through some transformation and enrichment steps before being loaded into BigQuery. Which of the following pipeline designs would best meet this requirement?
  A : Use Pub/Sub to capture streaming data from the application, then use Dataflow to transform and enrich the data before loading it into BigQuery.
  
  B : Write a Cloud Function to read data from a file in Cloud Storage whenever the file is updated, process it, and load it into BigQuery.
  
  C : Set up Cloud Dataprep to transform the data, then use a batch job to load the data into BigQuery every hour.
  
  D : Set up a Cloud Scheduler job to trigger the pipeline every minute, pulling data from the database, transforming it, and loading it into BigQuery.
  
  Answer: A
Question 3
- Your team wants to generate a report using BigQuery to identify top-selling products. They want to see the product name along with its total sales, sorted in descending order of total sales. Which SQL query best fits this requirement?
  A : SELECT
  product_id,
  transaction_amount AS total_sales
  FROM
  transactions
  ORDER BY
  total_sales DESC;
  
  B : SELECT
  product_name,
  COUNT(transaction_id) AS total_sales
  FROM
  transactions
  GROUP BY
  product_name
  ORDER BY
  total_sales DESC;
  
  C : SELECT
  product_name,
  transaction_amount AS total_sales
  FROM
  transactions
  GROUP BY
  product_name;
  
  D : SELECT
  product_name,
  SUM(transaction_amount) AS total_sales
  FROM
  transactions
  GROUP BY
  product_name
  ORDER BY
  total_sales DESC;
  
  Answer: D
Question 4
- Your team is storing sensitive customer data in a Cloud Storage bucket. They want to ensure that only specific users within the organization have access to this data and want to prevent any possibility of the data being made public. Which configuration would best meet this requirement?
  A : Enable 'Fine-grained access control' on the bucket, and then set public read access on the bucket-level permissions.
  
  B : Use 'Uniform bucket-level access' and enable the 'Bucket Policy Only' feature to ensure access control is handled exclusively through IAM.
  
  C : Set the bucket-s permissions to 'Uniform bucket-level access' and assign the necessary IAM roles to specific users only.
  
  D : Configure the bucket with 'Uniform bucket-level access' and enable the 'Public access prevention' feature.
  
  Answer: D
Question 5
- You have a model registered in the Model Registry in Vertex AI and need to evaluate its performance over multiple versions for A/B testing in production. Which approach will best allow you to manage different versions effectively while ensuring they can be accessed and deployed as needed?
  A : Use Vertex AI Experimentation instead of Model Registry for version management.
  
  B : Override the model version in Model Registry each time you retrain to avoid clutter.
  
  C : Assign a unique alias to each model version in Model Registry for easier version tracking and deployment.
  
  D : Manually track all versions in a local database and deploy them to a staging environment one by one.
  
  Answer: C

Free Google Associate-Data-Practitioner Exam Questions

Absolute Free Associate-Data-Practitioner Exam Practice for Comprehensive Preparation