Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 431:

  Why would a Snowflake user create a secure view instead of a standard view?

  A. The secure view is only available to end users with the corresponding SECURE_ACCESS property.

  B. End users are unable to see the view definition, and internal optimizations differ with a secure view.

  C. With a secure view, the underlying data is replicated to a separate storage layer with enhanced encryption.

  D. Secure views support additional functionality that is not supported for standard views, such as column masking and row level access policies.

  Correct Answer: B

• Question 432:

  What privilege does a user need in order to receive or request data from the Snowflake Marketplace?

  A. CREATE DATA EXCHANGE LISTING

  B. CREATE SHARE

  C. IMPORT SHARE

  D. IMPORTED PRIVILEGES

  Correct Answer: D

• Question 433:

  How can a Snowflake user configure a virtual warehouse to support over 100 users if their company has Enterprise Edition?

  A. Add additional warehouses and configure them as a cluster.

  B. Set the auto-scale to 100.

  C. Use a multi-cluster warehouse.

  D. Use a larger warehouse.

  Correct Answer: C

• Question 434:

  What role is required to use Partner Connect?

  A. ACCOUNTADMIN

  B. ORGADMIN

  C. SECURITYADMIN

  D. SYSADMIN

  Correct Answer: A

• Question 435:

  A Snowflake user wants to share data using my_share with account xy12345.

  Which command should be used?

  A. grant usage on share my_share to account xy12345;

  B. grant select on share my_share to account xy12345;

  C. alter share my_share add accounts = xy12345;

  D. alter account xy12345 add share my_share;

  Correct Answer: C

• Question 436:

  Which identity providers are valid type values for federated authentication on the SAML_IDENTITY_PROVIDER parameter? (Choose two.)

  A. Identity Access Management (IAM)

  B. Microsoft Active Directory Federation Services (AD FS)

  C. OAuth

  D. Okta

  E. PingFederate

  Correct Answer: BD

• Question 437:

  Which Snowflake database object can be shared with other accounts?

  A. Tasks

  B. Pipes

  C. Secure User-Defined Functions (UDFs)

  D. Stored Procedures

  Correct Answer: C

• Question 438:

  What is the MOST efficient way to load streaming data into Snowflake?

  A. Use the COPY command.

  B. Use Snowpipe.

  C. Use the Load Data Wizard.

  D. Use tasks and streams.

  Correct Answer: B

• Question 439:

  A Snowflake query took 40 minutes to run. The results indicate that ‘Bytes spilled to local storage

  Correct Answer: B

• Question 440:

  What will be the output of the below query against the table name gold_data?

  select * from gold_data tablesample (100);

  A. It will return an empty sample.

  B. It will return a random 100 rows.

  C. It will return an entire table.

  D. It will produce an error message.

  Correct Answer: C