A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?

• A.Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.
• B.Use auto-ingest Snowpipes to load large files in a serverless model.
• C.Produce the largest files possible, reducing the overall number of files to process.
• D.Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.

Comment: *

Name: *

Email: *

Verification: *

Which function can be used to convert semi-structured data into rows and columns?

• A.TABLE
• B.FLATTEN
• C.PARSE_JSON
• D.JSON EXTRACT PATH TEXT

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake tool is recommended for data batch processing?

• A.SnowCD
• B.SnowSQL
• C.Snowsight
• D.The Snowflake API

Comment: *

Name: *

Email: *

Verification: *

Which pages are included in the Activity area of Snowsight? (Select TWO).

• A.Contacts
• B.Sharing settings
• C.Copy History
• D.Query History
• E.Automatic Clustering History

Comment: *

Name: *

Email: *

Verification: *

True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *