Crucial Exams

GCP Associate Cloud Engineer Practice Question

A developer in Cloud Shell must quickly learn how many rows in the Orders table of a Cloud Spanner database are currently in the PENDING state. The database is named "sales" and is hosted in the Spanner instance "europe-inst". Without writing any code, which single gcloud command will return the desired count directly in the terminal?

  • gcloud spanner databases query sales --instance=europe-inst --dml='SELECT COUNT(*) FROM Orders WHERE status="PENDING";'

  • gcloud spanner sessions execute --instance=europe-inst --database=sales --query='SELECT COUNT(*) FROM Orders WHERE status="PENDING";'

  • gcloud spanner databases execute-sql sales --instance=europe-inst --sql='SELECT COUNT(*) FROM Orders WHERE status="PENDING";'

  • gcloud sql databases execute sales --instance=europe-inst --sql='SELECT COUNT(*) FROM Orders WHERE status="PENDING";'

GCP Associate Cloud Engineer
Ensuring successful operation of a cloud solution
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot