单选题 You have two tables in an ANSI-SQL compliant database with identical columns that you need to quickly combine into a single table, removing duplicate rows from the result set.
What should you do?

A、 Use the JOIN operator in SQL to combine the tables.
B、 Use nested WITH statements to combine the tables.
C、 Use the UNION operator in SQL to combine the tables.
D、 Use the UNION ALL operator in SQL to combine the tables.
下载APP答题
由4l***xg提供 分享 举报 纠错

相关试题

单选题 You need to copy directory local-scripts and all of its contents from your local workstation to a Compute Engine virtual machine instance. Which command should you use?

A、图中A选项
B、图中B选项
C、图中C选项
D、图中D选项

单选题 You are planning to migrate a MySQL database to the managed Cloud SQL database for Google Cloud. You have Compute Engine virtual machine instances that will connect with this Cloud SQL instance. You do not want to whitelist IPs for the Compute Engine instances to be able to access Cloud SQL.
What should you do?

A、 Enable private IP for the Cloud SQL instance.
B、 Whitelist a project to access Cloud SQL, and add Compute Engine instances in the whitelisted project.
C、 Create a role in Cloud SQL that allows access to the database from external instances, and assign the Compute Engine instances to that role.
D、 Create a CloudSQL instance on one project. Create Compute engine instances in a different project. Create a VPN between these two projects to allow internal access to CloudSQL.

单选题 Your website is deployed on Compute Engine. Your marketing team wants to test conversion rates between 3 different website designs. Which approach should you use?

A、 Deploy the website on App Engine and use trac splitting.
B、 Deploy the website on App Engine as three separate services.
C、 Deploy the website on Cloud Functions and use trac splitting.
D、 Deploy the website on Cloud Functions as three separate functions.

单选题 You have deployed an HTTP(s) Load Balancer with the gcloud commands shown below.

Health checks to port 80 on the Compute Engine virtual machine instance are failing and no trac is sent to your instances. You want to resolve the problem.
Which commands should you run?

A、 gcloud compute instances add-access-cong ${NAME}-backend-instance-1
B、 gcloud compute instances add-tags ${NAME}-backend-instance-1 --tags http-server
C、 gcloud compute rewall-rules create allow-lb --network load-balancer --allow tcp --source-ranges 130.211.0.0/22,35.191.0.0/16 --direction INGRESS
D、 gcloud compute rewall-rules create allow-lb --network load-balancer --allow tcp --destination-ranges 130.211.0.0/22,35.191.0.0/16 -- direction EGRESS

单选题 You want to upload les from an on-premises virtual machine to Google Cloud Storage as part of a data migration. These les will be consumed by Cloud
DataProc Hadoop cluster in a GCP environment.
Which command should you use?

A、 gsutil cp [LOCAL_OBJECT] gs://[DESTINATION_BUCKET_NAME]/
B、 gcloud cp [LOCAL_OBJECT] gs://[DESTINATION_BUCKET_NAME]/
C、 hadoop fs cp [LOCAL_OBJECT] gs://[DESTINATION_BUCKET_NAME]/
D、 gcloud dataproc cp [LOCAL_OBJECT] gs://[DESTINATION_BUCKET_NAME]/

单选题 You have an application deployed in production. When a new version is deployed, some issues don't arise until the application receives trac from users in production. You want to reduce both the impact and the number of users affected.
Which deployment strategy should you use?

A、 Blue/green deployment
B、 Canary deployment
C、 Rolling deployment
D、 Recreate deployment

单选题 You migrated your applications to Google Cloud Platform and kept your existing monitoring platform. You now nd that your notication system is too slow for time critical problems.
What should you do?

A、 Replace your entire monitoring platform with Stackdriver.
B、 Install the Stackdriver agents on your Compute Engine instances.
C、 Use Stackdriver to capture and alert on logs, then ship them to your existing platform.
D、 Migrate some trac back to your old platform and perform AB testing on the two platforms concurrently.

单选题 You are deploying your application to a Compute Engine virtual machine instance with the Stackdriver Monitoring Agent installed. Your application is a unix process on the instance. You want to be alerted if the unix process has not run for at least 5 minutes. You are not able to change the application to generate metrics or logs.
Which alert condition should you congure?

A、 Uptime check
B、 Process health
C、 Metric absence
D、 Metric threshold