You launched a new gaming app almost three years ago. You have been uploading log files from the previous day to a separate Google BigQuery table with the table name format LOGS_yyyymmdd. You have been using table wildcard functions to generate daily and monthly reports for all time ranges. Recently, you discovered that some queries that cover long date ranges are exceeding the limit of 1,000 tables and failing. How can you resolve this issue?
Which of the following IAM roles does your Compute Engine account require to be able to run pipeline jobs?
You set up a streaming data insert into a Redis cluster via a Kafka cluster. Both clusters are running on
Compute Engine instances. You need to encrypt data at rest with encryption keys that you can create, rotate, and destroy as needed. What should you do?
All Google Cloud Bigtable client requests go through a front-end server ______ they are sent to a Cloud Bigtable node.
You are migrating a table to BigQuery and are deeding on the data model. Your table stores information related to purchases made across several store locations and includes information like the time of the transaction, items purchased, the store ID and the city and state in which the store is located You frequently query this table to see how many of each item were sold over the past 30 days and to look at purchasing trends by state city and individual store. You want to model this table to minimize query time and cost. What should you do?
Enter your email address to download Google.Professional-Data-Engineer.v2022-10-14.q166 Dumps