Snowflake SnowPro Core Exam 1 Questions and Answers 100% Correct
11 views 0 purchase
Course
Snowflake SnowPro Core
Institution
Snowflake SnowPro Core
Snowflake SnowPro Core Exam 1 Questions and Answers 100% CorrectSnowflake SnowPro Core Exam 1 Questions and Answers 100% CorrectSnowflake SnowPro Core Exam 1 Questions and Answers 100% Correct
What is the purpose of using the OBJECT_CONSTRUCT function with the COPY INTO command?
1. Convert the ro...
Snowflake SnowPro Core Exam 1
Questions and Answers 100% Correct
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. - ANSWER - 1
By default, which Snowflake role is required to create a share?
1. SECURITYADMIN
2. ORGADMIN
3. SHAREADMIN
4. ACCOUNTADMIN - ANSWER - 4
If auto-suspend is enabled for a Virtual Warehouse, the Warehouse is automatically suspended
when:
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. - ANSWER - 4
Which Snowflake edition (and above) allows until 90 days of Time Travel?
1. Business Critical.
2. Virtual Private Snowflake
3. Standard.
4. Enterprise. - ANSWER - 4
,What are the key characteristics of ACСOUNT_USAGE views? (Choose two.)
1. The historical data can be retained from 7 days to 6 months.
2. Records for dropped objects are included in each view.
3. The data latency can vary from 45 minutes to 3 hours.
4. The historical data is not retained.
5. There is no data latency. - ANSWER - 2,3
Query results are stored in the Result Cache for how long after they are last accessed,
assuming no data changes have occurred?
1. 24 hours
2. 1 Hour
3. 12 hours
4. 3 Hours - ANSWER - 1
What are the types of data consumer accounts available in Snowflake? (Choose two.)
1. Reader Account
2. Subscriber account
3. Full Account
4. Public Account
5. Shared Account - ANSWER - 1,3
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
1. To accommodate more queries
2. To accommodate a more complex workload
3. To accommodate more users
4. To accommodate fluctuations in workload - ANSWER - 2
Which item in the Data Warehouse migration process does not apply in Snowflake?
1. Migrate Schemas
2. Build the Data Pipeline
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. - ANSWER - 2,4,6
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 - ANSWER - 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 - ANSWER - 3
What is the Snowflake multi-clustering feature for virtual warehouses used for?
1. To speed up slow or stalled queries
2. To improve concurrency for users and queries
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 NursingTutor1. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
