Home

Home / Snowflake / SnowPro Core

Question list

List of questions

Question 1

(0)

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file

Question 2

(0)

What are the default Time Travel and Fail-safe retention periods for transient tables?

Question 3

(0)

What is a best practice after creating a custom role?

Question 4

(0)

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

Question 5

(0)

Will data cached in a warehouse be lost when the warehouse is resized?

Question 6

(0)

What happens when a virtual warehouse is resized?

Question 7

(0)

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data

Question 8

(0)

Which of the following describes how clustering keys work in Snowflake?

Question 9

(0)

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Question 10

(0)

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

Open VPLUS File

Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)

When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?

A user needs to create a materialized view in the schema MYDB.MYSCHEM

Which Snowflake technique can be used to improve the performance of a query?

What is a key feature of Snowflake architecture?

A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

User-level network policies can be created by which of the following roles? (Select TWO).

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

Will data cached in a warehouse be lost when the warehouse is resized?

Question 611 - SnowPro Core discussion

Report

Which SQL statement will require a virtual warehouse to run?

A.

SELECT COUNT{*) FROM TBL_EMPLOYEE;

B.

ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGI0N VARCHAR(20);

C.

INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1,'Adam*,20000,* Finance');

D.

CREATE OR REPLACE TABLE TBL_EMPLOYEE ( EMP_ID NUMBER, EMP_NAME VARCHAR(30), EMP_SALARY NUMBER, DEPT VARCHAR{20) );

Show Answer

asked 29/10/2024

Souf Maatoug

40 questions

User

Your answer: A B C D

0 comments

Sorted by

Leave a comment first