Exam (elaborations)
Snowflake SnowPro Core Exam 1; Questions with Solutions Graded A+
- Course
- Institution
Snowflake SnowPro Core Exam 1; Questions with Solutions Graded A+
[Show more]
Content preview
Snowflake SnowPro Core Exam 1; Questions withSolutions 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller TheeGrades. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $16.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now