New Year Sale Special - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO

command was executed:

COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

The load failed with this error:

Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

How can this issue be resolved?

A.

Compress the file and load the compressed file.

B.

Split the file into multiple files in the recommended size range (100 MB - 250 MB).

C.

Use a larger-sized warehouse.

D.

Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

A.

INSERT

B.

PUT

C.

GET

D.

COPY

Where is Snowflake metadata stored?

A.

Within the data files

B.

In the virtual warehouse layer

C.

In the cloud services layer

D.

In the remote storage layer

Which of the following can be used when unloading data from Snowflake? (Choose two.)

A.

When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

B.

Use the ENCODING file format option to change the encoding from the default UTF-8.

C.

The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

D.

By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

E.

Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

A.

VARIANT

B.

VARRAY

C.

STRUCT

D.

ARRAY

E.

QUEUE

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.

What will occur?

A.

No virtual warehouse will be used, data will be read from the result cache.

B.

No virtual warehouse will be used, data will be read from the local disk cache.

C.

The default virtual warehouse will be used to read all data.

D.

The virtual warehouse that is defined at the session level will be used to read all data.

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

A.

When the system has enough load for 2 minutes

B.

When the system has enough load for 6 minutes

C.

When the system has enough load for 8 minutes

D.

When the system has enough load for 10 minutes

When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

A.

There is no need to have a Snowflake account in the target region, a share will be created for each user.

B.

The listing is replicated into all selected regions automatically, the data is not.

C.

The user must have the ORGADMIN role available in at least one account to link accounts for replication.

D.

Shares attached to listings in remote regions can be viewed from any account in an organization.

E.

For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

What is the default file size when unloading data from Snowflake using the COPY command?

A.

5 MB

B.

8 GB

C.

16 MB

D.

32 MB

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

A.

Snowflake leverages a Role-Based Access Control (RBAC) model.

B.

Snowflake requires a user to configure an IAM user to connect to the database.

C.

All data in Snowflake is encrypted.

D.

Snowflake can run within a user's own Virtual Private Cloud (VPC).

E.

All data in Snowflake is compressed.