- All Exams Instant Download
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?A . Data is hashed by the cluster key to facilitate fast searches for common data values B. Larger micro-partitions are created for common data values to reduce the number of partitions that...
What would be the MOST efficient way to get the files into Snowflake?
A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?A . Create a task that runs a copy into operation from an external stage every 5 minutes B. Create...
Which of the following statements is true of Snowflake?
Which of the following statements is true of Snowflake?A . It was built specifically for the cloud B. It was built as an on-premises solution and then ported to the cloud C. It was designed as a hybrid database to allow customers to store data either on premises or in...
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...
The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers
The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answersA . The complexity of each query B. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account C. The size of the data required for each query D. The tool that s executing the queryView...
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)A . Is available to all Snowflake Editions B. Is only available to customers with Business Critical Edition C. Restricts or enables access to specific IP addresses D. Is activated using an “ALTER DATABASE” commandView AnswerAnswer: A,C Explanation:...
When can a Virtual Warehouse start running queries?
When can a Virtual Warehouse start running queries?A . 12am-5am B. Only during administrator defined time slots C. When its provisioning is complete D. After replicationView AnswerAnswer: C Explanation: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)A . ROLES B. POLICY_REFERENCES C. QUERY_HISTORY D. RESOURCE_MONIT ORS E. ACCESS_HISTORYView AnswerAnswer: B,C Explanation: https://docs.snowflake.com/en/user-guide/security-column-ddm-intro.html#:~:text=DESCRIBE%20MASKING%20POLICY-,Auditing%20Dynamic%20Data%20Masking,a%20masking%20policy%20is%20set.
Which of the following are true of multi-cluster Warehouses? Select all that apply below.
Which of the following are true of multi-cluster Warehouses? Select all that apply below.A . A multi-cluster Warehouse can add clusters automatically based on query activity B. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity C. A multi-cluster Warehouse can scale down when query activity...
True or False: Snowflake charges a premium for storing semi-structured data.
True or False: Snowflake charges a premium for storing semi-structured data.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges-premium-for-storing-semi-structured-data
