What is the recommended action to do in order to switch between SSD and HDD storage for your Google Cloud Bigtable instance?

• A.create a third instance and sync the data from the two storage types via batch jobs
• B.export the data from the existing instance and import the data into a new instance
• C.run parallel instances where one is HDD and the other is SDD
• D.the selection is final and you must resume using the same storage type

Comment: *

Name: *

Email: *

Verification: *

Which of the following are feature engineering techniques? (Select 2 answers)

• A.Hidden feature layers
• B.Feature prioritization
• C.Crossed feature columns
• D.Bucketization of a continuous feature

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements is NOT true regarding Bigtable access roles?

• A.Using IAM roles, you cannot give a user access to only one table in a project, rather than all tables in a project.
• B.To give a user access to only one table in a project, grant the user the Bigtable Editor role for that table.
• C.You can configure access control only at the project level.
• D.To give a user access to only one table in a project, you must configure access through your application.

Comment: *

Name: *

Email: *

Verification: *

You are using Google BigQuery as your data warehouse. Your users report that the following simple query is running very slowly, no matter when they run the query:
SELECT country, state, city FROM [myproject:mydataset.mytable] GROUP BY country You check the query plan for the query and see the following output in the Read section of Stage:1:

What is the most likely cause of the delay for this query?

• A.The [myproject:mydataset.mytable] table has too many partitions
• B.Most rows in the [myproject:mydataset.mytable] table have the same value in the country column, causing data skew
• C.Users are running too many concurrent queries in the system
• D.Either the state or the city columns in the [myproject:mydataset.mytable] table have too many NULL values

Comment: *

Name: *

Email: *

Verification: *

You have enabled the free integration between Firebase Analytics and Google BigQuery. Firebase now automatically creates a new table daily in BigQuery in the format app_events_YYYYMMDD.You want to query all of the tables for the past 30 days in legacy SQL. What should you do?

• A.Use the TABLE_DATE_RANGEfunction
• B.Use the WHERE_PARTITIONTIMEpseudo column
• C.Use WHEREdate BETWEEN YYYY-MM-DD AND YYYY-MM-DD
• D.Use SELECT IF.(date >= YYYY-MM-DD AND date <= YYYY-MM-DD

Comment: *

Name: *

Email: *

Verification: *