[Sep 01, 2021]  SnowPro-Core PDF Dumps is essential on your SnowPro-Core Exam Questions Certain Success!

SnowPro-Core PDF Questions - Perfect Prospect To Go With SnowPro-Core Practice Exam

NEW QUESTION 64
True or False: It is possible to load data into Snowflake without creating a named File Format object.

• A. True
• B. False

Answer: A

 

NEW QUESTION 65
A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

• A. The queries currently being run by the Virtual Warehouse
• B. The primary duster in the virtual warehouse
• C. The entire Virtual Warehouse
• D. The database the Virtual Warehouse resides in

Answer: C

 

NEW QUESTION 66
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

• A. A Warehouse can be resized while running
• B. A Warehouse can be configured to suspend after a period of inactivity
• C. A Warehouse can be configured to auto-resume when new queries are submitted
• D. Customers can change the size of the Warehouse after creation

Answer: A,B,C,D

 

NEW QUESTION 67
Which type of table corresponds to a single Snowflake session?

• A. Provisional
• B. Temporary
• C. Translent
• D. Permanent

Answer: B

 

NEW QUESTION 68
True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

• A. False
• B. True

Answer: A

 

NEW QUESTION 69
Snowflake is designed for which type of workloads? (Choose two.)

• A. OLTP (Transactional) workloads
• B. On-premise workloads
• C. Concurrent workloads
• D. OLAP (Analytics) workloads

Answer: A,D

 

NEW QUESTION 70
How would you execute a series of SQL statements using Task?

• A. include the SQL statements in the body of the task create task mytask.. as insert into target1 select., from stream_s1 where ..
  INSERT INTO target2 SELECT .. FROM stream .s1 where ..
• B. A stored procedure can have only one DML statement per stored procedure invocation and therefore you should sequence stored procedures calls in the task definition CREATE TASK mytask.... AS call stored_prc1(); call stored_proc2t);
• C. Create a task for each SQL statement (e.g. resulting in task1. task2, etc) and string the series of SQL statements by having a control task calling task 1, task 2 sequentially.
• D. A stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask.... AS call stored_proc_multiple_statements_inside():

Answer: D

 

NEW QUESTION 71
Which statements are true of micro-partitions? (Choose two.)

• A. They are stored compressed only if COMPRESS=TRUE on Table
• B. They are approximately 16MB in size
• C. They are immutable
• D. They are only encrypted in the Enterprise edition and above

Answer: B,C

Explanation:
Explanation/Reference: https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1-
731ddc983c69

 

NEW QUESTION 72
What is the recommended Snowflake data type to store semi-structured data like JSON?

• A. LOB
• B. RAW
• C. VARIANT
• D. VARCHAR

Answer: C

Explanation:
Explanation/Reference: https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html

 

NEW QUESTION 73
On which of the following cloud platform can a Snowflake account be hosted?
Choose 2 answers

• A. Private Virtual Cloud
• B. Oracle Cloud
• C. Microsoft Azure Cloud
• D. Amazon Web Services

Answer: C,D

 

NEW QUESTION 74
True or False: You can resize a Virtual Warehouse while queries are running.

• A. True
• B. False

Answer: A

 

NEW QUESTION 75
True or False: The user has to specify which cluster a query will run on in a multi-cluster Warehouse.

• A. True
• B. False

Answer: A

Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

 

NEW QUESTION 76
True or False: Snowpipe via REST API can only reference External Stages as source.

• A. False
• B. True

Answer: A

Explanation:
Explanation/Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

 

NEW QUESTION 77
True or False: Pipes can be suspended and resumed.

• A. False
• B. True

Answer: A

Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

 

NEW QUESTION 78
True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.

• A. false
• B. True

Answer: A

 

NEW QUESTION 79
Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answers

• A. ODBC
• B. HIVE
• C. SnowSQL
• D. R

Answer: A,C

 

NEW QUESTION 80
True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).

• A. False
• B. True

Answer: A

 

NEW QUESTION 81
Which of the following terms best describes Snowflake's database architecture?

• A. Columnar shared nothing
• B. Cloud-native shared memory
• C. Shared disk
• D. Multi-cluster, shared data

Answer: C

 

NEW QUESTION 82
......

SnowPro-Core Exam with Accurate SnowPro Core Certification Exam PDF Questions: https://www.braindumpsit.com/SnowPro-Core_real-exam.html

True Snowflake Exam Extraordinary Practice For the SnowPro-Core Exam: https://drive.google.com/open?id=1ZPquvIh4bjqBlNQaWMvDtnfQVAjI8_lW