Master 2021 Latest The Questions SnowPro Core and Pass SnowPro-Core Real Exam! [Q86-Q111]

Master 2021 Latest The Questions SnowPro Core and Pass SnowPro-Core  Real Exam!

Penetration testers simulate SnowPro-Core exam PDF

NEW QUESTION 86
Which of the following statements are true of Snowflake releases: (Choose two.)

• A. They happen approximately weekly
• B. During a release, new customer requests/queries/connections transparently move over to the newer version
• C. They roll up and release approximately monthly, but customers can request early release application
• D. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded

Answer: B,D

 

NEW QUESTION 87
Which of the following statement is true of Snowflake?
Select one.

• A. It was built for Hadoop architecture
• B. it was built as an on-premises solution and then potted to the cloud
• C. It's based on an Oracle Architecture
• D. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
• E. It was built specifically for the cloud

Answer: E

 

NEW QUESTION 88
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

• A. Warehouse size
• B. Amount of data processed
• C. # of clusters for the Warehouse
• D. Number of users

Answer: A,B

 

NEW QUESTION 89
Which of the following objects is not covered by Time Travel?

• A. Schemas
• B. Tables
• C. Databases
• D. Stages

Answer: D

 

NEW QUESTION 90
Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
Select one:

• A. SECURITYADMIN, ACCOUNTADMIN
• B. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
• C. ACCOUNTADMIN
• D. SECURITYADMIN ACCOUNTADMIN, SYSADMIN

Answer: C

 

NEW QUESTION 91
True or False: The COPY command must specify a File Format in order to execute.

• A. True
• B. False

Answer: A

 

NEW QUESTION 92
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 93
Which statement best describes Snowflake tables?

• A. Snowflake tables are owned by a user
• B. Snowflake tables ate the physical instantiation of data loaded Into Snowflake
• C. Snowflake tables require that clustering keys be defined to perform optimally
• D. Snowflake tables are logical representations of underlying physical data

Answer: D

 

NEW QUESTION 94
The Query History in the Snowflake Web Interface (UI) is kept for approximately:

• A. 60 minutes
• B. 14 days
• C. 24 hours
• D. 1 year
• E. 30 days

Answer: B

 

NEW QUESTION 95
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 96
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

• A. Enterprise
• B. Standard
• C. Business Critical Edition
• D. Premier

Answer: A

 

NEW QUESTION 97
What is the maximum compressed row size in Snowflake?

• A. 16MB
• B. 8KB
• C. 50MB
• D. 4000GB

Answer: A

 

NEW QUESTION 98
True or False: Snowflake charges additional fees to Data providers for each share they create.

• A. True
• B. False

Answer: A

 

NEW QUESTION 99
Fail-safe is unavailable on which table types?

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

Answer: A,C

 

NEW QUESTION 100
What are the three layers that make up Snowflake's architecture?
Choose 3 answer

• A. Storage
• B. Tri-Secret Secure
• C. Cloud Services
• D. Compute

Answer: A,C,D

 

NEW QUESTION 101
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

• A. False
• B. True

Answer: A

 

NEW QUESTION 102
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

• A. True
• B. False

Answer: A

 

NEW QUESTION 103
Which statement best describes '' clustering''?

• A. The database administrator must define the clustering methodology for each Snowflake table.
• B. Clustering represents the way data is grouped together and stored within snowflake's micro-partitions
• C. Clustering can be disabled within a Snowflake account.
• D. The clustering key must be included on the COPV command when loading data into Snowflake.

Answer: B

 

NEW QUESTION 104
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

• A. True
• B. False

Answer: A

 

NEW QUESTION 105
If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

• A. There are no users loaned into Snowflake.
• B. The Warehouse is inactive for a specified period of time.
• C. The last query using the warehouse completes.
• D. All Snowflake sessions using the warehouse are terminated.

Answer: B

 

NEW QUESTION 106
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

• A. The REFRESH parameter is set to TRUE
• B. Previously loaded files will be ignored
• C. The Pipe load history is reset to empty
• D. All of the above

Answer: A

Explanation:
Explanation

 

NEW QUESTION 107
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 108
True or False: Snowflake charges additional fees to Data Providers for each Share they create.

• A. True
• B. False

Answer: A

Explanation:
Explanation/Reference: https://1amiydhcmj36tz3733v94f15-wpengine.netdna-ssl.com/wp-content/uploads/2017/08/ Enabling-new-products-and-services-with-Snowflake-Data-Sharing.pdf

 

NEW QUESTION 109
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 110
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 111
......

Penetration testers simulate SnowPro-Core exam: https://www.practicetorrent.com/SnowPro-Core-practice-exam-torrent.html

Bestselling On-The-Job Reference Exam Questions: https://drive.google.com/open?id=1HnvltYc_u8bTR7bBxerTJRkeD0um8AYB