ARA-R01 試験問題を無料オンラインアクセス

A data platform team creates two multi-cluster virtual warehouses with the AUTO_SUSPEND value set to NULL on one. and '0' on the other. What would be the execution behavior of these virtual warehouses?

• A.Setting a '0' or NULL value means the warehouses will never suspend.
• B.Setting a '0' or NULL value means the warehouses will suspend immediately.
• C.Setting a '0' value means the warehouses will suspend immediately, and NULL means the warehouses will never suspend.
• D.Setting a '0' or NULL value means the warehouses will suspend after the default of 600 seconds.

Which Snowflake objects can be used in a data share? (Select TWO).

• A.Stored procedure
• B.Stream
• C.Secure view
• D.Standard view
• E.External table

Following objects can be cloned in snowflake

• A.Transient table
• B.Temporary table
• C.External tables
• D.Internal stages
• E.Permanent table

A Snowflake Architect Is working with Data Modelers and Table Designers to draft an ELT framework specifically for data loading using Snowpipe. The Table Designers will add a timestamp column that Inserts the current tlmestamp as the default value as records are loaded into a table. The Intent is to capture the time when each record gets loaded into the table; however, when tested the timestamps are earlier than the loae_take column values returned by the copy_history function or the Copy_HISTORY view (Account Usage).
Why Is this occurring?

• A.The Snowflake timezone parameter Is different from the cloud provider's parameters causing the mismatch.
• B.The Table Designer team has not used the localtimestamp or systimestamp functions in the Snowflake copy statement.
• C.The timestamps are different because there are parameter setup mismatches. The parameters need to be realigned
• D.The CURRENT_TIMEis evaluated when the load operation is compiled in cloud services rather than when the record is inserted into the table.

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

• A.The UPSERT command
• B.The CHANGE_DATA_CAPTURE command
• C.The CHANGES clause
• D.A STREAM object
• E.The MERGE command