QUESTION: 145 Exam Topic: 6, Main Questions Set C

You are a head of BI at a large enterprise company with multiple business units that each have different priorities and budgets. You use on-demand pricing for BigQuery with a quota of 2K concurrent on-demand slots per project. Users at your organization sometimes don't get slots to execute their query and you need to correct this. You'd like to avoid introducing new projects to your account.

What should you do?

Convert your batch BQ queries into interactive BQ queries.
Create an additional project to overcome the 2K on-demand per-project quota.
Switch to flat-rate pricing and establish a hierarchical priority model for your projects.
Increase the amount of concurrent slots per project at the Quotas page at the Cloud Console.

Answer(s): C

Explanation:

Reference https://cloud.google.com/blog/products/gcp/busting-12-myths-about-bigquery

Reveal Solution Next Question

QUESTION: 146 Exam Topic: 6, Main Questions Set C

You are working on a linear regression model on BigQuery ML to predict a customer's likelihood of purchasing your company's products. Your model uses a city name variable as a key predictive component in order to train and serve the model your data must be organized in columns. You want to prepare your data using the least amount of coding while maintaining the predictable variables.
What should you do?

Use SQL in BigQuery to transform the stale column using a one-hot encoding method, and make each city a column with binary values.
Create a new view with BigQuery that does not include a column which city information.
Cloud Data Fusion to assign each city to a region that is labeled as 1, 2 3, 4, or 5, and then use that number to represent the city in the model.
Use TensorFlow to create a categorical variable with a vocabulary list. Create the vocabulary file and upload that as part of your model to BigQuery ML.

Answer(s): C

Reveal Solution Next Question

QUESTION: 147 Exam Topic: 6, Main Questions Set C

You are migrating your data warehouse to BigQuery. You have migrated all of your data into tables in a dataset. Multiple users from your organization will be using the data. They should only see certain tables based on their team membership. How should you set user permissions?

Assign the users/groups data viewer access at the table level for each table
Create SQL views for each team in the same dataset in which the data resides, and assign the users/groups data viewer access to the SQL views
Create authorized views for each team in the same dataset in which the data resides, and assign the users/groups data viewer access to the authorized views
Create authorized views for each team in datasets created for each team. Assign the authorized views data viewer access to the dataset in which the data resides. Assign the users/groups data viewer access to the datasets in which the authorized views reside

Answer(s): A

Reveal Solution Next Question

QUESTION: 148 Exam Topic: 6, Main Questions Set C

Your United States-based company has created an application for assessing and responding to user actions. The primary table's data volume grows by 250,000 records per second. Many third parties use your application's APIs to build the functionality into their own frontend applications. Your application's APIs should comply with the following requirements:

Single global endpoint
ANSI SQL support
Consistent access to the most up-to-date data

What should you do?

Implement BigQuery with no region selected for storage or processing.
Implement Cloud Spanner with the leader in North America and read-only replicas in Asia and Europe.
Implement Cloud SQL for PostgreSQL with the master in Norht America and read replicas in Asia and Europe.
Implement Cloud Bigtable with the primary cluster in North America and secondary clusters in Asia and Europe.

Answer(s): B

Reveal Solution Next Question

Free Google Cloud Certified Professional Data Engineer Exam Braindumps (page: 37)

QUESTION: 145 Exam Topic: 6, Main Questions Set C

Explanation:

QUESTION: 146 Exam Topic: 6, Main Questions Set C

QUESTION: 147 Exam Topic: 6, Main Questions Set C

QUESTION: 148 Exam Topic: 6, Main Questions Set C