Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 161:

  What affects whether the query results cache can be used?

  A. If the query contains a deterministic function

  B. If the virtual warehouse has been suspended

  C. If the referenced data in the table has changed

  D. If multiple users are using the same virtual warehouse

  Correct Answer: C

• Question 162:

  Network policies can be set at which Snowflake levels? (Choose two.)

  A. Role

  B. Schema

  C. User

  D. Database

  E. Account

  F. Tables

  Correct Answer: CE

  Reference: https://docs.snowflake.com/en/user-guide/network-policies.html#creating-network-policies

• Question 163:

  What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

  A. The explain plan output is available graphically.

  B. An explain plan can be used to conduct performance analysis without executing a query.

  C. An explain plan will handle queries with temporary tables and the query profiler will not.

  D. An explain plan's output will display automatic data skew optimization information.

  Correct Answer: B

• Question 164:

  Which of the following are characteristics of security in Snowflake?

  A. Account and user authentication is only available with the Snowflake Business Critical edition.

  B. Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

  C. Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

  D. Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

  Correct Answer: C

• Question 165:

  Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

  A. Database replication and failover

  B. Automated index management

  C. Customer managed keys (Tri-secret secure)

  D. Extended time travel

  E. Native support for geospatial data

  Correct Answer: DE

• Question 166:

  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: C

• Question 167:

  When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

  A. There is no need to have a Snowflake account in the target region, a share will be created for each user.

  B. The listing is replicated into all selected regions automatically, the data is not.

  C. The user must have the ORGADMIN role available in at least one account to link accounts for replication.

  D. Shares attached to listings in remote regions can be viewed from any account in an organization.

  E. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

  Correct Answer: BE

• Question 168:

  Which statement MOST accurately describes clustering in Snowflake?

  A. The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.

  B. Clustering is the way data is grouped together and stored within Snowflake micro-partitions.

  C. The clustering key must be included in the COPY command when loading data into Snowflake.

  D. Clustering can be disabled within a Snowflake account.

  Correct Answer: B

• Question 169:

  How does Snowflake Fail-safe protect data in a permanent table?

  A. Fail-safe makes data available up to 1 day, recoverable by user operations.

  B. Fail-safe makes data available for 7 days, recoverable by user operations.

  C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

  D. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

  Correct Answer: C

• Question 170:

  What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

  A. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 30 days. Fail Safe retention time is 1 day.

  B. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 365 days. Fail Safe retention time is 7 days.

  C. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.

  D. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.

  E. Default Time Travel Retention is set to 7 days. Maximum Time Travel Retention is 1 day. Fail Safe retention time is 90 days.

  F. Default Time Travel Retention is set to 90 days. Maximum Time Travel Retention is 7 days. Fail Safe retention time is 356 days.

  Correct Answer: D