Online Access Free ARA-R01 Practice Test

A company has an external vendor who puts data into Google Cloud Storage. The company's Snowflake account is set up in Azure.
What would be the MOST efficient way to load data from the vendor into Snowflake?

• A.Copy the data from Google Cloud Storage to Azure Blob storage using external tools and load data from Blob storage to Snowflake.
• B.Ask the vendor to create a Snowflake account, load the data into Snowflake and create a data share.
• C.Create a Snowflake Account in the Google Cloud Platform (GCP), ingest data into this account and use data replication to move the data from GCP to Azure.
• D.Create an external stage on Google Cloud Storage and use the external table to load the data into Snowflake.

Which of the below commands will use warehouse credits?

• A.SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;
• B.SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;
• C.SELECT COUNT(*) FROM SNOWFLAKE;
• D.SHOW TABLES LIKE 'SNOWFL%';

When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?

• A.CONTINUE
• B.FAIL
• C.SKIP_FILE
• D.ABORT_STATEMENT

What does a Snowflake Architect need to consider when implementing a Snowflake Connector for Kafka?

• A.The default retention time for Kafka topics is 14 days.
• B.The Kafka connector will create one table and one pipe to ingest data for each topic. If the connector cannot create the table or the pipe it will result in an exception.
• C.Every Kafka message is in JSON or Avro format.
• D.The Kafka connector supports key pair authentication, OAUTH. and basic authentication (for example, username and password).

What is a characteristic of Role-Based Access Control (RBAC) as used in Snowflake?

• A.A user can use a "super-user" access along with securityadmin to bypass authorization checks and access all databases, schemas, and underlying objects.
• B.A user can create managed access schemas to support future grants and ensure only schema owners can grant privileges to other roles.
• C.Privileges can be granted at the database level and can be inherited by all underlying objects.
• D.A user can create managed access schemas to support current and future grants and ensure only object owners can grant privileges to other roles.