How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?

• A.Use Snowpipe.
• B.Use an external table.
• C.Use the INSERT command.
• D.Use the COPY command.

Comment: *

Name: *

Email: *

Verification: *

What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?

• A.Convert the rows in a relational table lo a single VARIANT column and then unload the rows into a file.
• B.Reorder the rows in a relational table and then unload the rows into a file
• C.Reorder the data columns according to a target table definition and then unload the rows into the table.
• D.Convert the rows in a source file to a single variant column and then load the rows from the file to a variant table.

Comment: *

Name: *

Email: *

Verification: *

What happens when a virtual warehouse is resized?

• A.When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
• B.When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
• C.The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
• D.Users who are trying to use the warehouse will receive an error message until the resizing is complete

Comment: *

Name: *

Email: *

Verification: *

How does the Snowflake search optimization service improve query performance?

• A.It improves the performance of range searches.
• B.It defines different clustering keys on the same source table.
• C.It improves the performance of all queries running against a given table.
• D.It improves the performance of equality searches.
• E.It improves the performance of equality searches: The service optimizes the performance of queries that use equality search conditions (e.g., WHERE column = value). It creates and maintains a search index on the table's columns, which significantly speeds up the retrieval of rows based on those equality search conditions.

Comment: *

Name: *

Email: *

Verification: *

How can a user access information about a query execution plan without consuming virtual warehouse compute resources?

• A.Use the EXPLAIN function.
• B.Review the data in the Account_Usage view.
• C.Use the Snowsight dashboard.
• D.Review the Query Profile metrics.

Comment: *

Name: *

Email: *

Verification: *