A Data Engineer ran a stored procedure containing various transactions During the execution, the session abruptly disconnected preventing one transactionfrom committing or rolling hark.The transaction was left in a detached state and created a lock on resources
...must the Engineer take to immediately run a new transaction?

• A.Call the system function SYSTEM$ABORT_TRANSACTION.
• B.Call the system function SYSTEM$CANCEL_TRANSACTION.
• C.Set the LOCK_TIMEOUTto FALSE in the stored procedure
• D.Set the transaction abort on error to true in the stored procedure.

Comment: *

Name: *

Email: *

Verification: *

Jeff, a Data Engineer, accessing elements in JSON object in its 3 data loading scripts, he unknow-ingly use the upper case while accessing the elements. e.g.
Script 1 --> fruits:apple.sweet
Script 2 --> FRUITS:apple.sweet
Script 3 --> FRUITS:Apple.Sweet
Which are the correct statements?

• A.Script 1 & Script 2 traverse path twill be treated same, but Script 2 will not.
• B.Script 1,2,3 traverse path will treat in same way.
• C.Script 1 & 3 traverse path will be treated in same way.
• D.Script 2&3 traverse path will be same.

Comment: *

Name: *

Email: *

Verification: *

A company is using Snowpipe to bring in millions of rows every day of Change Data Capture (CDC) into a Snowflake staging table on a real-time basis The CDC needs to get processedand combined with other data in Snowflake and land in a final table as part of the full data pipeline.
How can a Data engineer MOST efficiently process the incoming CDC on an ongoing basis?

• A.Create a stream on the staging table and schedule a task that transforms data from the stream only when the stream has data.
• B.Transform the data during the data load with Snowpipe by modifying the related copy into statement to include transformation steps such as case statements andJOIN'S.
• C.Schedule a task that dynamically retrieves the last time the task was run from information_schema-rask_hiSwOry and use that timestamp to process the delta of the new rows since the last time the task was run.
• D.Use a create ok replace table as statement that references the staging table and includes all the transformation SQL. Use a task to run the full create or replace table as statement on a scheduled basis

Comment: *

Name: *

Email: *

Verification: *

Data Engineer decided to call the public REST endpoints to load data and retrieve load history re-ports. Which of the following REST endpoints and a Snowflake Information Schema table function for viewing your load history can be used by her? [Select All that apply]

• A.REST endpoints: loadinsertReport or HistoryScan
• B.Information Schema table function: COPY_HISTORY
• C.Account Usage view:COPY_HISTORY
• D.REST endpoints: insertReport or loadHistoryScan
• E.Information Schema table function: LOAD_HISTORY

Comment: *

Name: *

Email: *

Verification: *

Which Role that is dedicated to user and role management only?

• A.SECURITYADMIN
• B.ORGADMIN
• C.PUBLIC
• D.USERADMIN
• E.SYSADMIN

Comment: *

Name: *

Email: *

Verification: *