Google Updated Professional-Data-Engineer Exam Questions and Answers by jonathan

If you have existing data in a separate file for each day, then create a partitioned table and upload each file into the appropriate partition.

Run a query to get the records for a specific day from an existing table and for the destination table, specify a partitioned table ending with the day in the format "$YYYYMMDD".

Create a partitioned table and stream new records to it every day.

Use ORDER BY to put a table's rows into chronological order and then change the table's type to "Partitioned".

By default, a query's results are not cached.

BigQuery caches query results for 48 hours.

Query results are cached even if you specify a destination table.

There is no charge for a query that retrieves its results from cache.

Using IAM roles, you cannot give a user access to only one table in a project, rather than all tables in a project.

To give a user access to only one table in a project, grant the user the Bigtable Editor role for

that table.

You can configure access control only at the project level.

To give a user access to only one table in a project, you must configure access through your application.

The workload isn't appropriate for Cloud Bigtable.

The table's schema is not designed correctly.

The Cloud Bigtable cluster has too many nodes.

There are issues with the network connection.