What are Invalid rules applicable when using stored procedure contains transaction?

• A.If a transaction is started inside a stored procedure and is still active when the stored procedure finishes, then an error occurs, and the transaction is rolled back.
• B.A transaction inside a stored procedure can include a call to another stored procedure that contains a transaction.
• C.You cannot start a transaction before calling the stored procedure, then complete the transaction inside the stored procedure.
• D.All Rules are Applicable.
• E.A transaction can be inside a stored procedure, or a stored procedure can be inside a transaction.
• F.You cannot start a transaction inside the stored procedure, then complete the transac-tion after returning from the procedure.

Comment: *

Name: *

Email: *

Verification: *

A Data Engineer is building a pipeline to transform a 1 TD tab e by joining it with supplemental tables The Engineer is applying filters and several aggregations leveraging Common TableExpressions (CTEs) using a size Medium virtual warehouse in a single query in Snowflake.
After checking the Query Profile, what is the recommended approach to MAXIMIZE performance of this query if the Profile shows data spillage?

• A.Enable clustering on the table
• B.Increase the warehouse size
• C.Rewrite the query to remove the CTEs.
• D.Switch to a multi-cluster virtual warehouse

Comment: *

Name: *

Email: *

Verification: *

Find out the odd one out:

• A.1. Bulk Data Load: Loads are always performed in a single transaction.
  2. SnowPipe: Loads are combined or split into a single or multiple transactions based on the number and size of the rows in each data file.
• B.1. Bulk Data Load: Requires a user-specified warehouse to execute COPY statements.
  2. SnowPipe: Uses Snowflake-supplied compute resources.
• C.1. Bulk Data Load: Billed for the amount of time each virtual warehouse is active.
  2. SnowPipe: Billed according to the compute resources used in the Snowpipe ware-house while loading the files.
• D.1. Bulk Data Load: Load history Stored in the metadata of the target table for 365 days.
  2. SnowPipe: Load history Stored in the metadata of the pipe for 64 days.

Comment: *

Name: *

Email: *

Verification: *

A stream called TRANSACTIONS_STM is created on top of a transactions table in a continuous pipeline running in Snowflake. After a couple of months, the TRANSACTIONS table is renamed transactiok3_raw to comply with new naming standards What will happen to the TRANSACTIONS _STM object?

• A.TRANSACTIONS _STMwill keep working as expected
• B.TRANSACTIONS _STMwill be stale and will need to be re-created
• C.TRANSACTIONS _STMwill be automatically renamedTRANSACTIONS _RAW_STM.
• D.Reading from the traksactioks_3T>: stream will succeed for some time after the expected STALE_TIME.

Comment: *

Name: *

Email: *

Verification: *

Data Engineer, ran the below clustering depth analysis function:
select system$clustering_depth('TPCH_CUSTOMERS', '(C1, C6)', 'C9 = 30'); on TPCH_CUSTOMERS table, will return which of the following?

• A.An error: this function does not accept predicates ('C9 = 30') as parameter.
• B.Calculate the clustering depth for a table using mentioned columns in the table.
• C.Calculate the clustering depth for a table using the clustering key defined for the table.
• D.An error: this function does not accept lists of columns as a third parameter.

Comment: *

Name: *

Email: *

Verification: *