QUESTION NO: 1
Your team wants to create a monthly report to analyze inventory data that is updated daily. You need to aggregate the inventory counts by using only the most recent month of data, and save the results to be used in a Looker Studio dashboard. What should you do?
Your team wants to create a monthly report to analyze inventory data that is updated daily. You need to aggregate the inventory counts by using only the most recent month of data, and save the results to be used in a Looker Studio dashboard. What should you do?
Correct Answer: B
Vote an answer
QUESTION NO: 2
You need to create a new data pipeline. You want a serverless solution that meets the following requirements:
* Data is streamed from Pub/Sub and is processed in real-time.
* Data is transformed before being stored.
* Data is stored in a location that will allow it to be analyzed with SQL using Looker.
Which Google Cloud services should you recommend for the pipeline?
You need to create a new data pipeline. You want a serverless solution that meets the following requirements:
* Data is streamed from Pub/Sub and is processed in real-time.
* Data is transformed before being stored.
* Data is stored in a location that will allow it to be analyzed with SQL using Looker.
Which Google Cloud services should you recommend for the pipeline?
Correct Answer: C
Vote an answer
QUESTION NO: 3
You are designing a BigQuery data warehouse with a team of experienced SQL developers. You need to recommend a cost- effective, fully-managed, serverless solution to build ELT processes with SQL pipelines.
Your solution must include source code control, environment parameterization, and data quality checks. What should you do?
You are designing a BigQuery data warehouse with a team of experienced SQL developers. You need to recommend a cost- effective, fully-managed, serverless solution to build ELT processes with SQL pipelines.
Your solution must include source code control, environment parameterization, and data quality checks. What should you do?
Correct Answer: C
Vote an answer
QUESTION NO: 4
Your organization has decided to move their on-premises Apache Spark-based workload to Google Cloud.
You want to be able to manage the code without needing to provision and manage your own cluster. What should you do?
Your organization has decided to move their on-premises Apache Spark-based workload to Google Cloud.
You want to be able to manage the code without needing to provision and manage your own cluster. What should you do?
Correct Answer: B
Vote an answer
QUESTION NO: 5
You used BigQuery ML to build a customer purchase propensity model six months ago. You want to compare the current serving data with the historical serving data to determine whether you need to retrain the model.
What should you do?
You used BigQuery ML to build a customer purchase propensity model six months ago. You want to compare the current serving data with the historical serving data to determine whether you need to retrain the model.
What should you do?
Correct Answer: C
Vote an answer
QUESTION NO: 6
Your organization has decided to migrate their existing enterprise data warehouse to BigQuery. The existing data pipeline tools already support connectors to BigQuery. You need to identify a data migration approach that optimizes migration speed. What should you do?
Your organization has decided to migrate their existing enterprise data warehouse to BigQuery. The existing data pipeline tools already support connectors to BigQuery. You need to identify a data migration approach that optimizes migration speed. What should you do?
Correct Answer: B
Vote an answer
QUESTION NO: 7
You are predicting customer churn for a subscription-based service. You have a 50 PB historical customer dataset in BigQuery that includes demographics, subscription information, and engagement metrics. You want to build a churn prediction model with minimal overhead. You want to follow the Google-recommended approach. What should you do?
You are predicting customer churn for a subscription-based service. You have a 50 PB historical customer dataset in BigQuery that includes demographics, subscription information, and engagement metrics. You want to build a churn prediction model with minimal overhead. You want to follow the Google-recommended approach. What should you do?
Correct Answer: A
Vote an answer