A Review Of Approved SnowPro-Core Exam Topics

NEW QUESTION 1

A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?

• A. Okta Verify
• B. Duo Mobile
• C. Microsoft Authenticator
• D. Google Authenticator

Answer: B

Explanation:
https://docs.snowflake.com/en/user-guide/security-mfa.html

NEW QUESTION 2

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

• A. CREATE_SHARE on the account
• B. SHARE on databases and schemas
• C. SELECT on tables used by the secure view
• D. REFERENCE_USAGE on databases

Answer: C

NEW QUESTION 3

What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

• A. Row level access policies
• B. Data masking policies
• C. Data encryption
• D. Time Travel
• E. External tokenization

Answer: CD

NEW QUESTION 4

Which of the following accurately describes shares?

• A. Tables, secure views, and secure UDFs can be shared
• B. Shares can be shared
• C. Data consumers can clone a new table from a share
• D. Access to a share cannot be revoked once granted

Answer: A

NEW QUESTION 5

Which stage type can be altered and dropped?

• A. Database stage
• B. External stage
• C. Table stage
• D. User stage

Answer: C

Explanation:
https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#table-stages

NEW QUESTION 6

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

• A. True
• B. False

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

NEW QUESTION 7

Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously?
Choose 3 answers

• A. MIN(< < column value>>)
• B. COPY
• C. SUM(<< column value >>)
• D. UPDATE

Answer: BCD

NEW QUESTION 8

True or False: Fail-safe can be disabled within a Snowflake account.

• A. True
• B. False

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail safe feature cannot be enabled or disabled from the user end .

NEW QUESTION 9

What is the default File Format used in the COPY command if one is not specified?

• A. CSV
• B. JSON
• C. Parquet
• D. XML

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html

NEW QUESTION 10

A user is preparing to load data from an external stage
Which practice will provide the MOST efficient loading performance?

• A. Organize files into logical paths
• B. Store the files on the external stage to ensure caching is maintained
• C. Use pattern matching for regular expression execution
• D. Load the data in one large file

Answer: D

NEW QUESTION 11

How many days is load history for Snowpipe retained?

• A. 1 day
• B. 7 days
• C. 14 days
• D. 64 days

Answer: C

NEW QUESTION 12

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

• A. An FTP server with TLS encryption
• B. An HTTPS server with WebDAV
• C. A Google Cloud storage bucket
• D. A Windows server file share on Azure

Answer: C

NEW QUESTION 13

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

• A. STRIP_NULL_VALUES
• B. SKIP_BYTE_ORDER_MARK
• C. REPLACE_INVALID_CHARACTERS
• D. VALIDATION_MODE

Answer: D

Explanation:
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
VALIDATION_MODE = RETURnN__ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS
String (constant) that instructs the COPY command to validate the data files instead
of loading them into the
specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:

NEW QUESTION 14

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip outer_array file format option
What does the STRIP_OUTER_ARRAY file format do?

• A. It removes the last element of the outer array.
• B. It removes the outer array structure and loads the records into separate table rows,
• C. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
• D. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

Answer: B

Explanation:
Data Size Limitations
The VARIANT data type imposes a 16 MB size limit on individual rows.
For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents. The JSON output from some software is composed of a single huge array containing multiple records. There is no need to separate the documents with line breaks or commas, though both are supported.
If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format option for the COPY INTO
<table> command to remove the outer array structure and load the records into separate table rows:
copy into <table> from @~/<file>.json
file_format = (type = 'JSON' strip_outer_array = true); https://docs.snowflake.com/en/user-guide/semistructured-considerations.html

NEW QUESTION 15

Which statement about billing applies to Snowflake credits?

• A. Credits are billed per-minute with a 60-minute minimum
• B. Credits are used to pay for cloud data storage usage
• C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs
• D. Credits are consumed based on the warehouse size and the time the warehouse is running

Answer: D

Explanation:
Snowflake credits are used to pay for the consumption of resources on Snowflake. A Snowflake credit is a unit of measure, and it is consumed only when a customer is using resources, such as when a virtual warehouse is running, the cloud services layer is performing work, or serverless features are used.
https://docs.snowflake.com/en/user-guide/what-are-credits.html

NEW QUESTION 16
......