Which interfaces can be used to create and/or manage Virtual Warehouses?

Which interfaces can be used to create and/or manage Virtual Warehouses?A . The Snowflake Web Interface (UI) B. SQL commands C. Data integration tools D. All of the aboveView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses.html

June 13, 2023 No Comments READ MORE +

According to recommended best practice, what should be done to reduce the Queue volume?

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).A . Use multi-clustered warehousing to scale out...

June 13, 2023 No Comments READ MORE +

Select the different types of Internal Stages: (Choose three.)

Select the different types of Internal Stages: (Choose three.)A . Named Stage B. User Stage C. Table Stage D. Schema StageView AnswerAnswer: A,B,C Explanation: Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal-Named-Stage

June 13, 2023 No Comments READ MORE +

What can be used to view warehouse usage over time? (Select Two).

What can be used to view warehouse usage over time? (Select Two).A . The load HISTORY view B. The Query history view C. The show warehouses command D. The WAREHOUSE_METERING__HISTORY View E. The billing and usage tab in the Snowflake web UlView AnswerAnswer: D,E

June 13, 2023 No Comments READ MORE +

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).A . The user has the appropriate privileges on the objects associated with the query B. Micro-partitions have been reclustered since the query was last run C. The new query is run...

June 13, 2023 No Comments READ MORE +

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?A . The primary cluster in the virtual warehouse B. The entire virtual warehouse C. The database in which the virtual warehouse resides D. The Queries currently being run on the virtual warehouseView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual% 20clusters%20in%20the%20warehouse.

June 13, 2023 No Comments READ MORE +

True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.A . True B. FalseView AnswerAnswer: A

June 13, 2023 No Comments READ MORE +

Which of the following objects can be cloned? (Choose four.)

Which of the following objects can be cloned? (Choose four.) A. Tables B. Named File Formats C. Schemas D. Shares E. Databases F. UsersView AnswerAnswer: A.C.E.F Explanation: The following objects can be cloned in Snowflake: Tables: You can create a clone of a table using the CREATE TABLE ... CLONE...

June 12, 2023 No Comments READ MORE +

What privileges are required to create a task?

What privileges are required to create a task?A . The global privilege create task is required to create a new task. B. Tasks are created at the Application level and can only be created by the Account Admin role. C. Many Snowflake DDLs are metadata operations only, and create task...

June 12, 2023 No Comments READ MORE +

True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

True or False: A Snowflake account is charged for data stored in both Internal and External Stages.A . True B. FalseView AnswerAnswer: B Explanation: A Snowflake account is charged for data stored in Internal Stages. However, data stored in External Stages such as Amazon S3, Google Cloud Storage, or Microsoft...

June 12, 2023 No Comments READ MORE +