Download Free Snowflake ARA-C01 Real Exam Questions Download [Q17-Q36]

Posted byadminJune 26, 2023Leave a Comment on Download Free Snowflake ARA-C01 Real Exam Questions Download [Q17-Q36]

Rate this post

Download Free Snowflake ARA-C01 Real Exam Questions Download

Latest Snowflake ARA-C01 Real Exam Dumps PDF

NEW QUESTION 17
A company has several sites in different regions from which the company wants to ingest data.
Which of the following will enable this type of data ingestion?

The company must have a Snowflake account in each cloud region to be able to ingest data to that account.

The company must replicate data between Snowflake accounts.

The company should provision a reader account to each site and ingest the data through the reader accounts.

The company should use a storage integration for the external stage.

NEW QUESTION 18
Which semi-structured data function returns an OBJECT constructed from the arguments.

OBJECT_CONSTRUCT

OBJECT_ARRAY

OBJECT_INSPECT

NEW QUESTION 19
A company has a Snowflake account named ACCOUNTA in AWS us-east-1 region. The company stores its marketing data in a Snowflake database named MARKET_DB. One of the company’s business partners has an account named PARTNERB in Azure East US 2 region. For marketing purposes the company has agreed to share the database MARKET_DB with the partner account.
Which of the following steps MUST be performed for the account PARTNERB to consume data from the MARKET_DB database?

Create a new account (called AZABC123) in Azure East US 2 region. From account ACCOUNTA create a share of database MARKET_DB, create a new database out of this share locally in AWS us-east-1 region, and replicate this new database to AZABC123 account. Then set up data sharing to the PARTNERB account.

From account ACCOUNTA create a share of database MARKET_DB, and create a new database out of this share locally in AWS us-east-1 region. Then make this database the provider and share it with the PARTNERB account.

Create a new account (called AZABC123) in Azure East US 2 region. From account ACCOUNTA replicate the database MARKET_DB to AZABC123 and from this account set up the data sharing to the PARTNERB account.

Create a share of database MARKET_DB, and create a new database out of this share locally in AWS us-east-1 region. Then replicate this database to the partner’s account PARTNERB.

NEW QUESTION 20
By default, the maximum file size that can be unloaded to a single file in snowflake is

10 MB

16 MB

5 GB for Azure, AWS and GCP

NEW QUESTION 21
An Architect runs the following SQL query:

How can this query be interpreted?

FILEROWS is a stage. FILE_ROW_NUMBER is line number in file.

FILEROWS is the table. FILE_ROW_NUMBER is the line number in the table.

FILEROWS is a file. FILE_ROW_NUMBER is the file format location.

FILERONS is the file format location. FILE_ROW_NUMBER is a stage.

NEW QUESTION 22
An Architect on a new project has been asked to design an architecture that meets Snowflake security, compliance, and governance requirements as follows:
1) Use Tri-Secret Secure in Snowflake
2) Share some information stored in a view with another Snowflake customer
3) Hide portions of sensitive information from some columns
4) Use zero-copy cloning to refresh the non-production environment from the production environment To meet these requirements, which design elements must be implemented? (Choose three.)

Define row access policies.

Use the Business Critical edition of Snowflake.

Create a secure view.

Use the Enterprise edition of Snowflake.

Use Dynamic Data Masking.

Create a materialized view.

NEW QUESTION 23
Shares are first-class objects in Snowflake for which Snowflake provides a set of DDL commands for creating and managing shares

TRUE

FALSE

NEW QUESTION 24
A user has the appropriate privilege to see unmasked data in a column.
If the user loads this column data into another column that does not have a masking policy, what will occur?

Unmasked data will be loaded in the new column.

Masked data will be loaded into the new column.

Unmasked data will be loaded into the new column but only users with the appropriate privileges will be able to see the unmasked data.

Unmasked data will be loaded into the new column and no users will be able to see the unmasked data.

NEW QUESTION 25
The insertReport endpoint can be thought of like the UNIX command tail

TRUE

FALSE

NEW QUESTION 26
With default settings, how long will a query run on snowflake

Snowflake will cancel the query if it runs more than 48 hours

Snowflake will cancel the query if it runs more than 24 hours

Snowflake will cancel the query if the warehouse runs out of memory

Snowflake will cancel the query if the warehouse runs out of memory and hard disk storage

NEW QUESTION 27
All multi cluster warehouses that were using the Legacy policy now use the default Standard policy

TRUE

FALSE

NEW QUESTION 28
You have written a procedure and a function in snowflake.
How do you find your procedures and functions in snowflake?

SHOW PROCEDURES;

SHOW FUNCTIONS;

SHOW ALL PROCEDURES AND FUNCTIONS

SHOW PROCEDURES, FUNCTIONS

NEW QUESTION 29
Data replication in snowflake helps in

Disaster recovery

Data sharing

Account Migration

Fail safe

NEW QUESTION 30
Files stored in snowflake internal stage are automatically encrypted using either AES 128 or 256 strong encryption.

TRUE

FALSE

NEW QUESTION 31
Which copy options are not supported by CREATE PIPE…AS COPY FROM command?

FILES = ( ‘file_name1’ [ , ‘file_name2’, … ] )

FORCE = TRUE | FALSE

ON_ERROR = ABORT_STATEMENT

VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS

MATCH_BY_COLUMN_NAME = CASE_SENSITIVE | CASE_INSENSITIVE | NONE

NEW QUESTION 32
You have create a table in snowflake as below
CREATE TABLE EMPLOYEE(EMPLOYEE_NAME STRING, SALARY NUMBER); When you do a DESCRIBE TABLE EMPLOYEE, what will you see as the data type of EMPLOYEE_NAME?

VARCHAR(10)

VARCHAR

VARCHAR(16777216)

STRING

NEW QUESTION 33
Validation mode can take the below options

RETURN_<n>_ROWS

RETURN_ERRORS

RETURN_ALL_ERRORS

RETURN_SEVERE_EERORS_ONLY

NEW QUESTION 34
The following DDL command was used to create a task based on a stream:

Assuming MY_WH is set to auto_suspend – 60 and used exclusively for this task, which statement is true?