Snowflake SnowPro-Core Quiz 3 Topic 8 Questions 11-15

Question: 1

Which Snowflake tool would be BEST to troubleshoot network connectivity?

ASnowCLI

BSnowUI

CSnowSQL

DSnowCD

Show Answer

Question: 2

Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

AQuery execution

BData loading

CTime Travel data

DSecurity

EAuthentication and access control

Show Answer

Question: 3

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

ADatabase replication and failover

BAutomated index management

CCustomer managed keys (Tri-secret secure)

DExtended time travel

ENative support for geospatial data

Show Answer

Question: 4

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

Which of the following statements will accommodate this request?

AALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

BGRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

CGRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

DGRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Show Answer

Question: 5

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

Which of the following statements will accommodate this request?

AALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

BGRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

CGRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

DGRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Show Answer

Snowflake SnowPro-Core Quiz:3 Topic:8 Questions:11-15