Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 171:

  What COPY INTO SQL command should be used to unload data into multiple files?

  A. SINGLE=TRUE

  B. MULTIPLE=TRUE

  C. MULTIPLE=FALSE

  D. SINGLE=FALSE

  Correct Answer: D

• Question 172:

  What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

  A. Business Critical Edition

  B. Standard Edition

  C. Virtual Private Snowflake (VPS)

  D. Enterprise Edition

  Correct Answer: B

• Question 173:

  Which Snowflake layer is always leveraged when accessing a query from the result cache?

  A. Metadata

  B. Data Storage

  C. Compute

  D. Cloud Services

  Correct Answer: D

• Question 174:

  What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

  A. Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

  B. All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

  C. The ACCOUNTADMIN role must be granted to only one user.

  D. Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

  E. All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

  Correct Answer: AD

• Question 175:

  How often are the Account and Table master keys automatically rotated by Snowflake?

  A. 30 Days

  B. 60 Days

  C. 90 Days

  D. 365 Days.

  Correct Answer: A

• Question 176:

  When loading data into Snowflake, how should the data be organized?

  A. Into single files with 100-250 MB of compressed data per file

  B. Into single files with 1-100 MB of compressed data per file

  C. Into files of maximum size of 1 GB of compressed data per file

  D. Into files of maximum size of 4 GB of compressed data per file

  Correct Answer: A

• Question 177:

  Which of the following statements describes a schema in Snowflake?

  A. A logical grouping of objects that belongs to a single database

  B. A logical grouping of objects that belongs to multiple databases

  C. A named Snowflake object that includes all the information required to share a database

  D. A uniquely identified Snowflake account within a business entity

  Correct Answer: A

• Question 178:

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

  A. There is minimal cost associated with running the query.

  B. The query consumes many compute resources every time it runs.

  C. The base table gets updated frequently.

  D. The query is highly optimized and does not consume many compute resources.

  E. The results of the query do not change often and are used frequently.

  Correct Answer: BE

  https://docs.snowflake.com/en/user-guide/views-materialized.html#deciding-when-to-create-a-materialized-view

• Question 179:

  The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

  A. USERADMIN

  B. PUBLIC

  C. ORGADMIN

  D. SYSADMIN

  Correct Answer: A

  https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html#using-the-accountadmin-role By default, when your account is provisioned, the first user is assigned the ACCOUNTADMIN role. This user should then create one or more additional users who are assigned the USERADMIN role. All remaining users should be created by the user(s) with the USERADMIN role or another role that is granted the global CREATE USER privilege

• Question 180:

  The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

  

  A user needs to extract the dealership information from the JSON. How can this be accomplished?

  A. select src:dealership from car_sales;

  B. select src.dealership from car_sales;

  C. select src:Dealership from car_sales;

  D. select dealership from car_sales;

  Correct Answer: A