True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.A . True B. FalseView AnswerAnswer: A Explanation: Query result cache is all about fetching the data from cloud services layer and saving the cost by not running...

October 26, 2022 No Comments READ MORE +

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:...

October 26, 2022 No Comments READ MORE +

Which practice will provide the MOST efficient loading performance?

A user is preparing to load data from an external stage Which practice will provide the MOST efficient loading performance?A . Organize files into logical paths B. Store the files on the external stage to ensure caching is maintained C. Use pattern matching for regular expression execution D. Load the...

October 26, 2022 No Comments READ MORE +

Which of the following statements would be used to export/unload data from Snowflake?

Which of the following statements would be used to export/unload data from Snowflake?A . COPY INTO @stage B. EXPORT TO @stage C. INSERT INTO @stage D. EXPORT_TO_STAGE (stage = > @Wage, select = > 'select * from t1);View AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

October 25, 2022 No Comments READ MORE +

which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.

which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.A . Bulk copy from an External Stage B. Continuous load using Snowpipe REST API C. The Snowflake Web Interface (UT) data loading wizard D. Bulk copy from an Internal StageView...

October 25, 2022 No Comments READ MORE +

Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)

Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)A . Growth of storage and compute are tightly coupled together B. Storage expands without the requirement to add more compute C. Compute can be scaled up or down without the requirement...

October 25, 2022 No Comments READ MORE +

Which of the following statement is true of Snowflake?

Which of the following statement is true of Snowflake?A . It was built specifically for the cloud B. it was built as an on-premises solution and then potted to the cloud C. It was designed as a hybrid database to allow customers to store data either on premises or in...

October 25, 2022 No Comments READ MORE +

What happens when a cloned table is replicated to a secondary database? (Select TWO)

What happens when a cloned table is replicated to a secondary database? (Select TWO)A . A read-only copy of the cloned tables is stored. B. The replication will not be successful. C. The physical data is replicated D. Additional costs for storage are charged to a secondary account E. Metadata...

October 25, 2022 No Comments READ MORE +

True or False: All Snowflake table types include fail-safe storage.

True or False: All Snowflake table types include fail-safe storage.A . True B. FalseView AnswerAnswer: B

October 25, 2022 No Comments READ MORE +

Which of the following are benefits of micro-partitioning? (Select TWO)

Which of the following are benefits of micro-partitioning? (Select TWO)A . Micro-partitions cannot overlap in their range of values B. Micro-partitions are immutable objects that support the use of Time Travel. C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses D. Rows are automatically stored...

October 24, 2022 No Comments READ MORE +