What is the purpose of a stream in Snowflake?

• A.To process and move data from multiple sources into Snowflake in real time
• B.To provide a mechanism to deliver live or recorded media content to global cross-cloud users in real time
• C.To record changes made to table data and metadata, so that the changed data can be processed
• D.To process high volumes of data in a continuous, incremental manner using low-latency processing

Comment: *

Name: *

Email: *

Verification: *

Which command is used to unload data from a Snowflake table into a file in a stage?

• A.COPY INTO
• B.GET
• C.WRITE
• D.EXTRACT INTO

Comment: *

Name: *

Email: *

Verification: *

How should the SPLIT_TO_TABLE( < string > , < delimiter > ) function be called?

• A.SELECT SPLIT_TO_TABLE < COL1, ' . ' > FROM DUAL;
• B.SELECT SPLIT_TO_TABLE( ' a.b.c ' , ' . ' );
• C.SELECT * FROM TABLE(SPLIT_TO_TABLE( ' a.b.c ' , ' . ' ));
• D.SELECT * FROM SPLIT_TO_TABLE( ' a-b.c ' , ' . ' );

Comment: *

Name: *

Email: *

Verification: *

Which function returns the URL of a stage using the stage name as the input?

• A.BUILD_STAGE_FILE_URL
• B.BUILD_SCOPED_FILE_URL
• C.GET_PRESIGNED_URL
• D.GET STAGE LOCATION

Comment: *

Name: *

Email: *

Verification: *

Bulk data is loaded daily from an external storage location by using the following command:
COPY INTO source_table
FROM ' s3://source/data/files '
STORAGE_INTEGRATION = s3_source_int
FILE_FORMAT = (FORMAT_NAME = source_format)
PATTERN = ' sales.*[.]csv ' ;
How will the data be loaded?

• A.All files that match the specified format will be appended every time the command runs.
• B.Only new files will be loaded; previously loaded files will be skipped.
• C.All files matching s3://source/data/files/*.csv will be loaded from an internal stage.
• D.The source table will be truncated, and all files from the location will be loaded.

Comment: *

Name: *

Email: *

Verification: *