Free SNOWPRO-CORE sample questions
Each free SnowPro Core sample question below comes with the correct answer and an explanation. The set mixes architecture, security, data loading and data sharing. Work through it to see which parts of the platform you need to review.
Try them in the simulator Same questions, with study, timed and flashcard modes.
Showing 10 of 20 free sample questions.
A compliance officer needs to prevent a group of junior analysts from seeing the raw values in a column containing social security numbers (`SSN`), but the analysts still need to perform joins on that column. Which Snowflake security feature should be implemented to meet this requirement?
When using the `COPY INTO ` command with `VALIDATION_MODE = RETURN_ERRORS`, Snowflake will not load any data into the target table, even if some rows are valid.
An analyst is investigating a query that is performing poorly. Upon reviewing the query profile, they notice a significant amount of 'Bytes spilled to local storage'. What does this indicate?
**Case Study:** A healthcare analytics company, HealthData Inc., stores patient records in a table named `PATIENTS`. This table contains sensitive columns such as `FULL_NAME`, `DATE_OF_BIRTH`, and `DIAGNOSIS_CODE`. The company needs to implement a data governance strategy with the following requirements: 1. A `RESEARCHER` role should only see patients from their assigned hospital, determined by a mapping table `RESEARCHER_HOSPITAL_MAP`. They should not see any rows for patients from other hospitals. 2. The `RESEARCHER` role should see a masked version of `FULL_NAME` (e.g., 'P****** M***') but the `BILLING_ANALYST` role should see the full, unmasked name. 3. All access to the `PATIENTS` table must be logged for auditing purposes. Which combination of Snowflake features should be used to implement this governance strategy most effectively and securely?
A developer needs to create a user-defined function (UDF) that will process large, unstructured files (e.g., PDFs) located in a stage. The function needs to use a complex third-party Python library for parsing. Which approach should the developer take?
A company has two Snowflake accounts, one for production (in `us-east-1`) and one for analytics (in `eu-west-1`). They need to share data from a production table with the analytics account. Which statements about this data sharing scenario are true? (Select TWO) sequenceDiagram participant Prod_Acct as Production (us-east-1) participant Analytics_Acct as Analytics (eu-west-1) Prod_Acct->>Analytics_Acct: Creates Share & Grants Access Analytics_Acct->>Prod_Acct: Creates DB from Share Note right of Analytics_Acct: Data is NOT copied. Note left of Prod_Acct: Provider pays for storage. Note right of Analytics_Acct: Consumer pays for compute.
What happens when a query is executed that can be fully resolved by the result cache?
The `SYSTEMADMIN` role is a system-defined role that is intended for creating and managing compute resources (virtual warehouses) and database objects (databases, schemas, tables).
A data engineer is designing a data loading process for Parquet files stored in an S3 bucket. The Parquet files have a well-defined schema, but the target table in Snowflake should also include metadata about the source file, such as the filename and row number. How can the engineer include this metadata during the load process using a `COPY INTO` command?
10 more free samples are waiting
Create a free account to unlock the whole SNOWPRO-CORE sample bank, or get full access to all 218 practice questions in the simulator.