Free SnowPro-Core Exam Dumps

Question 91

- (Exam Topic 1)
Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers

A. Their default role should be set to SYSTEMADMIN (the lower of the two)
B. They should not set up multi_Factor Authentication (MFA)—as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so
C. They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation
D. They should ensure all database objects in the account are owned by the ACCOUNTADMIN role
E. They should use the SYSADMIN role to perform administrative work on database objects

Correct Answer:ACE

Question 92

- (Exam Topic 3)
Which of the following can be used when unloading data from Snowflake? (Choose two.)

A. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
B. Use the ENCODING file format option to change the encoding from the default UTF-8.
C. The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
D. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
E. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

Correct Answer:AD

Question 93

- (Exam Topic 2)
When is the result set cache no longer available? (Select TWO)

A. When another warehouse is used to execute the query
B. When another user executes the query
C. When the underlying data has changed
D. When the warehouse used to execute the query is suspended
E. When it has been 24 hours since the last query

Correct Answer:CE

Question 94

- (Exam Topic 3)
A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?

A. Use auto-ingest Snowpipes to load large files in a serverless model.
B. Produce the largest files possible, reducing the overall number of files to process.
C. Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.
D. Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

Correct Answer:B

Question 95

- (Exam Topic 1)
True or False: It is possible to load data into Snowflake without creating a named File Format object.

A. True
B. False

Correct Answer:A
Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html