A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?

• A.Create a task that runs a copy into operation from an external stage every 5 minutes
• B.Create a task that puts the files in an internal stage and automate the data loading wizard
• C.Create a task that runs a GET operation to intermittently check for new files
• D.Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

Comment: *

Name: *

Email: *

Verification: *

What happens when a database is cloned?

• A.It does not retain any privileges granted on the source object.
• B.It replicates all granted privileges on the corresponding source objects.
• C.It replicates all granted privileges on the corresponding child objects.
• D.It replicates all granted privileges on the corresponding child schema objects.

Comment: *

Name: *

Email: *

Verification: *

How is unstructured data retrieved from data storage?

• A.SQL functions like the GET command can be used to copy the unstructured data to a location on the client.
• B.SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.
• C.SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client, the unstructured data will be output to the client as files.
• D.SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.

Comment: *

Name: *

Email: *

Verification: *

What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Select TWO).

• A.Performing aggregate calculations
• B.Reordering the columns
• C.Grouping by operations
• D.Converting the datatypes
• E.Selecting the first few rows

Comment: *

Name: *

Email: *

Verification: *

The PUT command: (Choose two.)

• A.Automatically creates a File Format object
• B.Automatically uses the last Stage created
• C.Automatically compresses files using Gzip
• D.Automatically encrypts files

Comment: *

Name: *

Email: *

Verification: *