Online SnowPro-Core Practice TestMore Snowflake Products >

Free Snowflake SnowPro-Core Exam Dumps Questions

Snowflake SnowPro-Core: SnowPro Core Certification Exam

- Get instant access to SnowPro-Core practice exam questions

- Get ready to pass the SnowPro Core Certification Exam exam right now using our Snowflake SnowPro-Core exam package, which includes Snowflake SnowPro-Core practice test plus an Snowflake SnowPro-Core Exam Simulator.

- The best online SnowPro-Core exam study material and preparation tool is here.

4.5

(6570 ratings)

Question 1

- (Exam Topic 3)
Which of the following is the Snowflake Account_Usage.Metering_History view used for?

A. Gathering the hourly credit usage for an account

B. Compiling an account's average cloud services cost over the previous month

C. Summarizing the throughput of Snowpipe costs for an account

D. Calculating the funds left on an account's contract

Correct Answer:A

Question 2

- (Exam Topic 1)
What is the lowest Snowflake edition that offers Time Travel up to 90 days?

A. standard Edition

B. Premier Edition

C. Enterprise Edition

D. Business Critical Edition

Correct Answer:C
Reference: https://docs.snowflake.com/en/user-guide/data-availability.html

Question 3

- (Exam Topic 3)
By default, which Snowflake role is required to create a share?

A. ORGADMIN

B. SECURITYADMIN

C. SHAREADMIN

D. ACCOUNTADMIN

Correct Answer:C

Question 4

- (Exam Topic 3)
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO
command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470. How can this issue be resolved?

A. Compress the file and load the compressed file.

B. Split the file into multiple files in the recommended size range (100 MB - 250 MB).

C. Use a larger-sized warehouse.

D. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

Correct Answer:A

Question 5

- (Exam Topic 1)
For a multi-cluster Warehouse, the number of credits billed is calculated on: Select one.

A. The number of queries that ran using the Warehouse.

B. The size of the Warehouse and the number of clusters that ran within a given time period.

C. The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.

D. The number of users who accessed the Warehouse.

Correct Answer:B

Question 6

- (Exam Topic 1)
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

A. Concurrency

B. Performance

Correct Answer:A
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

START SnowPro-Core EXAM