What are all of the BigQuery operations that Google charges for?

• A.Storage, queries, and streaming inserts
• B.Storage, queries, and loading data from a file
• C.Storage, queries, and exporting data
• D.Queries and streaming inserts

Comment: *

Name: *

Email: *

Verification: *

You decided to use Cloud Datastore to ingest vehicle telemetry data in real time. You want to build a storage system that will account for the long-term data growth, while keeping the costs low. You also want to create snapshots of the data periodically, so that you can make a point-in-time (PIT) recovery, or clone a copy of the data for Cloud Datastore in a different environment. You want to archive these snapshots for a long time.
Which two methods can accomplish this? Choose 2 answers.

• A.Use managed export, and store the data in a Cloud Storage bucket using Nearline or Coldline class.
• B.Use managed exportm, and then import to Cloud Datastore in a separate project under a unique namespace reserved for that export.
• C.Use managed export, and then import the data into a BigQuery table created just for that export, and delete temporary export files.
• D.Write an application that uses Cloud Datastore client libraries to read all the entities. Treat each entity as a BigQuery table row via BigQuery streaming insert. Assign an export timestamp for each export, and attach it as an extra column for each row. Make sure that the BigQuery table is partitioned using the export timestamp column.
• E.Write an application that uses Cloud Datastore client libraries to read all the entities. Format the exported data into a JSON file. Apply compression before storing the data in Cloud Source Repositories.

Comment: *

Name: *

Email: *

Verification: *

You need to choose a database to store time series CPU and memory usage for millions of computers.
You need to store this data in one-second interval samples. Analysts will be performing real-time, ad hoc analytics against the database. You want to avoid being charged for every query executed and ensure that the schema design will allow for future growth of the dataset. Which database and data model should you choose?

• A.Create a table in BigQuery, and append the new samples for CPU and memory to the table
• B.Create a wide table in BigQuery, create a column for the sample value at each second, and update the row with the interval for each second
• C.Create a narrow table in Cloud Bigtable with a row key that combines the Computer Engine computer identifier with the sample time at each second
• D.Create a wide table in Cloud Bigtable with a row key that combines the computer identifier with the sample time at each minute, and combine the values for each second as column data.

Comment: *

Name: *

Email: *

Verification: *

Which of the following is NOT a valid use case to select HDD (hard disk drives) as the storage for Google Cloud Bigtable?

• A.You expect to store at least 10 TB of data.
• B.You will mostly run batch workloads with scans and writes, rather than frequently executing random reads of a small number of rows.
• C.You need to integrate with Google BigQuery.
• D.You will not use the data to back a user-facing or latency-sensitive application.

Comment: *

Name: *

Email: *

Verification: *

Your chemical company needs to manually check documentation for customer order. You use a pull subscription in Pub/Sub so that sales agents get details from the order. You must ensure that you do not process orders twice with different sales agents and that you do not add more complexity to this workflow.
What should you do?

• A.Create a transactional database that monitors the pending messages.
• B.Create a new Pub/Sub push subscription to monitor the orders processed in the agent's system.
• C.Use Pub/Sub exactly-once delivery in your pull subscription.
• D.Use a Deduphcate PTransform in Dataflow before sending the messages to the sales agents.

Comment: *

Name: *

Email: *

Verification: *