Snowflake SnowPro Core Exam 1; Questions with
Solutions Graded A+
What is the purpose of using the OBJECT_CONSTRUCT function with the COPY INTO
command?
1. Convert the rows in a relational table to a single VARIANT column and then unload the
rows into a file.
2. Reorder the rows in a relational table and then unload the rows into a file.
3. Convert the rows in a source file to a single VARIANT column and then load the rows from
the file to a variant table.
4. Reorder the data columns according to a target table definition and then unload the rows
into the table. Correct Ans-1
By default, which Snowflake role is required to create a share?
1. SECURITYADMIN
2. ORGADMIN
3. SHAREADMIN
4. ACCOUNTADMIN Correct Ans-4
If auto-suspend is enabled for a Virtual Warehouse, the Warehouse is automatically
suspended when:
, Snowflake SnowPro Core Exam 1; Questions with
Solutions Graded A+
1. The last query using the Warehouse completes.
2. All Snowflakes sessions using the Warehouse are terminated.
3. There are no users logged into Snowflake.
4. The Warehouse is inactive for a specified period of time. Correct Ans-4
Which of the following statements are true concerning the Snowflake release process?
(Choose three.)
1. A customer is assigned a 30 minute window (that can be moved anytime within a week)
during which the system will be unavailable and customer is upgraded
2. Snowflake deploys new Behavior change releases every month.
3. Snowflake deploys patch releases every week, but new feature releases happen once a
month.
4. Snowflake deploys new feature releases and releases every week.
5. There is usually some minimal downtime associated with Snowflake during the
deployments.
6. It is possible for you as a user to request 24-hour early access to the upcoming releases so
that you can do additional release testing before the release is rolled out. Correct Ans-
2,4,6
, Snowflake SnowPro Core Exam 1; Questions with
Solutions Graded A+
What are the available Snowflake scaling modes for configuring multi-cluster virtual
warehouses? (Choose two.)
1. Economy
2. Maximized
3. Scale-Out
4. Auto-Scale
5. Standard Correct Ans-2,4
Snowflake will return an error when a user attempts to share which object?
1. Secure materialized views
2. Tables
3. Standard views
4. Secure views Correct Ans-3
What is the Snowflake multi-clustering feature for virtual warehouses used for?
1. To speed up slow or stalled queries
, Snowflake SnowPro Core Exam 1; Questions with
Solutions Graded A+
2. To improve concurrency for users and queries
3. To improve the data unloading process to the cloud
4. To improve data loading from very large data sets Correct Ans-2
Which loop type iterates until a condition is true?
1. FOR
2. LOOP
3. WHILE
4. REPEAT Correct Ans-4
The three main Snowflake layers are...
1. Extraction, Load, Transformation.
2. Database, Virtual Warehouse, Metadata.
3. Centralized Storage, Compute & Cloud Services.
4. Staging, Data Warehouse, Dimensional. Correct Ans-3
Solutions Graded A+
What is the purpose of using the OBJECT_CONSTRUCT function with the COPY INTO
command?
1. Convert the rows in a relational table to a single VARIANT column and then unload the
rows into a file.
2. Reorder the rows in a relational table and then unload the rows into a file.
3. Convert the rows in a source file to a single VARIANT column and then load the rows from
the file to a variant table.
4. Reorder the data columns according to a target table definition and then unload the rows
into the table. Correct Ans-1
By default, which Snowflake role is required to create a share?
1. SECURITYADMIN
2. ORGADMIN
3. SHAREADMIN
4. ACCOUNTADMIN Correct Ans-4
If auto-suspend is enabled for a Virtual Warehouse, the Warehouse is automatically
suspended when:
, Snowflake SnowPro Core Exam 1; Questions with
Solutions Graded A+
1. The last query using the Warehouse completes.
2. All Snowflakes sessions using the Warehouse are terminated.
3. There are no users logged into Snowflake.
4. The Warehouse is inactive for a specified period of time. Correct Ans-4
Which of the following statements are true concerning the Snowflake release process?
(Choose three.)
1. A customer is assigned a 30 minute window (that can be moved anytime within a week)
during which the system will be unavailable and customer is upgraded
2. Snowflake deploys new Behavior change releases every month.
3. Snowflake deploys patch releases every week, but new feature releases happen once a
month.
4. Snowflake deploys new feature releases and releases every week.
5. There is usually some minimal downtime associated with Snowflake during the
deployments.
6. It is possible for you as a user to request 24-hour early access to the upcoming releases so
that you can do additional release testing before the release is rolled out. Correct Ans-
2,4,6
, Snowflake SnowPro Core Exam 1; Questions with
Solutions Graded A+
What are the available Snowflake scaling modes for configuring multi-cluster virtual
warehouses? (Choose two.)
1. Economy
2. Maximized
3. Scale-Out
4. Auto-Scale
5. Standard Correct Ans-2,4
Snowflake will return an error when a user attempts to share which object?
1. Secure materialized views
2. Tables
3. Standard views
4. Secure views Correct Ans-3
What is the Snowflake multi-clustering feature for virtual warehouses used for?
1. To speed up slow or stalled queries
, Snowflake SnowPro Core Exam 1; Questions with
Solutions Graded A+
2. To improve concurrency for users and queries
3. To improve the data unloading process to the cloud
4. To improve data loading from very large data sets Correct Ans-2
Which loop type iterates until a condition is true?
1. FOR
2. LOOP
3. WHILE
4. REPEAT Correct Ans-4
The three main Snowflake layers are...
1. Extraction, Load, Transformation.
2. Database, Virtual Warehouse, Metadata.
3. Centralized Storage, Compute & Cloud Services.
4. Staging, Data Warehouse, Dimensional. Correct Ans-3
