单选题 You are designing BigQuery tables for large volumes of clickstream event data. Your data analyst team will most frequently query by specific event date ranges and filter by the user ID UUID. You want to optimize table structure for query cost and performance. What should you do?

A、 Partition the table by the user ID column and cluster the table by the event date column.

B、 Create an ingestion-time partitioned table and cluster it by the user ID column.

C、 Cluster the table by both the event date and the user ID columns.

D、 Partition the table by the event date column and cluster the table by user ID column.

由4m***7c提供分享举报纠错

相关试题

单选题 Your company wants to be able to retrieve large result sets of medical information from your current system, which has over 10 TBs in the database, and store the data in new tables for further query. The database must have a low-maintenance architecture and be accessible via SQL. You need to implement a cost-effective solution that can support data analytics for large result sets. What should you do?

A、Use Cloud SQL, but first organize the data into tables. Use JOIN in queries to retrieve data.

B、Use BigQuery as a data warehouse. Set output destinations for caching large queries.

C、Use a MySQL cluster installed on a Compute Engine managed instance group for scalability.

D、Use Cloud Spanner to replicate the data across regions. Normalize the data in a series of tables.

查看答案

单选题 You are loading CSV files from Cloud Storage to BigQuery. The files have known data quality issues, including mismatched data types, such as STRINGS and INT64s in the same column, and inconsistent formatting of values such as phone numbers or addresses. You need to create the data pipeline to maintain data quality and perform the required cleansing and transformation. What should you do?

A、Use Data Fusion to transform the data before loading it into BigQuery.

B、Use Data Fusion to convert the CSV files to a self-describing data format, such as AVRO, before loading the data to BigQuery.

C、Load the CSV files into a staging table with the desired schema, perform the transformations with SQL, and then write the results to the final destination table.

D、Create a table with the desired schema, load the CSV files into the table, and perform the transformations in place using SQL.

查看答案

单选题 You are developing a new deep learning model that predicts a customer's likelihood to buy on your ecommerce site. After running an evaluation of the model against both the original training data and new test data, you find that your model is overfitting the data. You want to improve the accuracy of the model when predicting new data. What should you do?

A、Increase the size of the training dataset, and increase the number of input features.

B、Increase the size of the training dataset, and decrease the number of input features.

C、Reduce the size of the training dataset, and increase the number of input features.

D、Reduce the size of the training dataset, and decrease the number of input features.

查看答案

单选题 An aerospace company uses a proprietary data format to store its flight data. You need to connect this new data source to BigQuery and stream the data into BigQuery. You want to efficiently import the data into BigQuery while consuming as few resources as possible. What should you do?

A、Write a shell script that triggers a Cloud Function that performs periodic ETL batch jobs on the new data source.

B、Use a standard Dataflow pipeline to store the raw data in BigQuery, and then transform the format later when the data is used.

C、Use Apache Hive to write a Dataproc job that streams the data into BigQuery in CSV format.

D、Use an Apache Beam custom connector to write a Dataflow pipeline that streams the data into BigQuery in Avro format.

查看答案

单选题 You are implementing a chatbot to help an online retailer streamline their customer service. The chatbot must be able to respond to both text and voice inquiries. You are looking for a low-code or no-code option, and you want to be able to easily train the chatbot to provide answers to keywords. What should you do?

A、Use the Cloud Speech-to-Text API to build a Python application in App Engine.

B、Use the Cloud Speech-to-Text API to build a Python application in a Compute Engine instance.

C、Use Dialogflow for simple queries and the Cloud Speech-to-Text API for complex queries.

D、Use Dialogflow to implement the chatbot, defining the intents based on the most common queries collected.

查看答案

单选题 Your startup has a web application that currently serves customers out of a single region in Asia. You are targeting funding that will allow your startup to serve customers globally. Your current goal is to optimize for cost, and your post-funding goal is to optimize for global presence and performance. You must use a native JDBC driver. What should you do?

A、Use Cloud Spanner to configure a single region instance initially, and then configure multi-region Cloud Spanner instances after securing funding.

B、Use a Cloud SQL for PostgreSQL highly available instance first, and Bigtable with US, Europe, and Asia replication after securing funding.

C、Use a Cloud SQL for PostgreSQL zonal instance first, and Bigtable with US, Europe, and Asia after securing funding.

D、Use a Cloud SQL for PostgreSQL zonal instance first, and Cloud SQL for PostgreSQL with highly available configuration after securing funding.

查看答案

单选题 You need to migrate 1 PB of data from an on-premises data center to Google Cloud. Data transfer time during the migration should take only a few hours. You want to follow Google-recommended practices to facilitate the large data transfer over a secure connection. What should you do?

A、Establish a Cloud Interconnect connection between the on-premises data center and Google Cloud, and then use the Storage Transfer Service.

B、Use a Transfer Appliance and have engineers manually encrypt, decrypt, and verify the data.

C、Establish a Cloud VPN connection, start gcloud compute scp jobs in parallel, and run checksums to verify the data.

D、Reduce the data into 3 TB batches, transfer the data using gsutil, and run checksums to verify the data.

查看答案

单选题 An online brokerage company requires a high volume trade processing architecture. You need to create a secure queuing system that triggers jobs. The jobs will run in Google Cloud and call the company's Python API to execute trades. You need to efficiently implement a solution. What should you do?

A、Use a Pub/Sub push subscription to trigger a Cloud Function to pass the data to the Python API.

B、Write an application hosted on a Compute Engine instance that makes a push subscription to the Pub/Sub topic

C、Write an application that makes a queue in a NoSQL database.

D、Use Cloud Composer to subscribe to a Pub/Sub topic and call the Python API.

查看答案