True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.

True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html

October 10, 2021 No Comments READ MORE +

True or False: Snowpipe via RFST API can only reference External Stages as source.

True or False: Snowpipe via RFST API can only reference External Stages as source.A . TrueB . FalseView AnswerAnswer: A

October 10, 2021 No Comments READ MORE +

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)A . UsersB . TablesC . DatabasesD . Internal StagesView AnswerAnswer: B,C,D

October 9, 2021 2 Comments READ MORE +

True or False: During data unloading, only JSON and CSV files can be compressed.

True or False: During data unloading, only JSON and CSV files can be compressed.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html

October 9, 2021 No Comments READ MORE +

Which of the following statements are true of Snowflake releases: (Choose two.)

Which of the following statements are true of Snowflake releases: (Choose two.)A . They happen approximately weeklyB . They roll up and release approximately monthly, but customers can request early release applicationC . During a release, new customer requests/queries/connections transparently move over to the newer versionD . A customer is...

October 9, 2021 No Comments READ MORE +

If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:A . All Snowflake sessions using the warehouse are terminated.B . The last query using the warehouse completes.C . There are no users loaned into Snowflake.D . The Warehouse is inactive for a specified period of time.View...

October 9, 2021 No Comments READ MORE +

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

October 9, 2021 No Comments READ MORE +

Which of the following commands are not blocking operations?

Which of the following commands are not blocking operations? Choose 2 answersA . UPDATEB . INSERTC . MERGED . COPYView AnswerAnswer: B,D

October 8, 2021 No Comments READ MORE +

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

October 8, 2021 No Comments READ MORE +

True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

October 8, 2021 No Comments READ MORE +