Snowflake SnowPro-Core Certification Exam Dumps with 164 Practice Test Questions
New SnowPro-Core Exam Dumps with High Passing Rate
How much SnowPro Core CertificationCost
The cost of the SnowPro Core Certification is $175. For more information related to exam price, please visit the official website as the cost of exams may be subjected to vary county-wise.
NEW QUESTION 50
True or False: Pipes can be suspended and resumed.
- A. True
- B. False
Answer: B
NEW QUESTION 51
Which of the following is true of Snowpipe via REST API?
Choose 2 answers
- A. Snowflake automatically manages the compute required to execute the Pipe's copy into commands
- B. Snowpipe keeps track of which files it has loaded
- C. you can only use it on internal Stages
- D. All COPY INTO options are available fluting pipe creation
Answer: A,B
NEW QUESTION 52
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers
- A. Translent Tables
- B. Temporary Tables
- C. Provisional Tables
- D. Permanent Tables
Answer: A,B
NEW QUESTION 53
When creating a user it is advisable sable to:
Choose 2 answers
- A. Set the users access to expire within a specified timeframe
- B. Set a default role for the user
- C. Force an immediate password change
- D. Set the number of minutes to unlock to 15 minutes
- E. Set the user to be initially disabled
Answer: B,C
NEW QUESTION 54
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
- A. 24 hours
- B. 3 Hours
- C. 12 hours
- D. 1 Hour
Answer: A
Explanation:
Explanation/Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse
NEW QUESTION 55
What privileges are required to execute a task?
- A. A task is an account-level object and can only be executed by the Account Admin role.
- B. Tasks run automatically and do run under any rote.
- C. Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.
- D. To execute a task, you need the EXECUTE TASK.
Answer: D
NEW QUESTION 56
Which of the following commands sets the Virtual Warehouse for a session?
- A. USE WAREHOUSE <<warehouse name>>;
- B. USE VIRTUAL_WAREHOUSE <<warehouse name>>;
- C. COPY WAREHOUSE FROM <<config file>>;
- D. SET WAREHOUSE = <<warehouse name>>;
Answer: A
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html
NEW QUESTION 57
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
- A. All of the above
- B. The Pipe load history is reset to empty
- C. Previously loaded files will be ignored
- D. The REFRESH parameter is set to TRUE
Answer: D
NEW QUESTION 58
True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.
- A. false
- B. True
Answer: A
NEW QUESTION 59
True or False: During data unloading, only JSON and CSV files can be compressed.
- A. True
- B. False
Answer: B
NEW QUESTION 60
Which interfaces can be used to create and/or manage Virtual Warehouses?
- A. SQL commands
- B. All of the above
- C. Data integration tools
- D. The Snowflake Web Interface (UI)
Answer: A
NEW QUESTION 61
True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.
- A. True
- B. False
Answer: B
NEW QUESTION 62
Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?
- A. Warehouses
- B. Worksheets
- C. Database
- D. Tables
Answer: A,B,C
NEW QUESTION 63
True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.
- A. True
- B. False
Answer: B
NEW QUESTION 64
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.
- A. True
- B. False
Answer: A
NEW QUESTION 65
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
- A. Set the Minimum Clusters and Maximum Clusters settings to the different values
- B. Set the Minimum Clusters and Maximum Clusters settings to the same value
- C. Configure the Maximum Clusters setting to "Auto-Scale"
- D. Set the Warehouse type to "Auto"
Answer: A
NEW QUESTION 66
Which of the following statements are true of Snowflake releases: (Choose two.)
- A. They roll up and release approximately monthly, but customers can request early release application
- B. They happen approximately weekly
- C. During a release, new customer requests/queries/connections transparently move over to the newer version
- D. 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
Answer: C,D
NEW QUESTION 67
Snowflake is designed for which type of workloads? (Choose two.)
- A. OLTP (Transactional) workloads
- B. On-premise workloads
- C. OLAP (Analytics) workloads
- D. Concurrent workloads
Answer: A,C
Explanation:
Explanation/Reference: https://blog.couchbase.com/its-the-workload-stupid/
NEW QUESTION 68
Account-level storage usage can be monitored via:
- A. The snowflake wet Interface (UI) in the Databases section.
- B. The Information Schema -> ACCOUNT_USAGE_HISTORY View
- C. The Snowflake web interface (UI) in the Account -> Billing a usage section
- D. The Account usage Schema - > ACCOUNT_USAGE_METRICS View
Answer: C
NEW QUESTION 69
When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers
- A. When you don't want to have to manually turn on the Warehouse each time a user needs it
- B. When managing a steady workload
- C. When the compute must be available with no delay or lag time
- D. When users will be using compute at different times throughout a 24/7 period
Answer: A,B
NEW QUESTION 70
What is the default File Format used in the COPY command if one is not specified?
- A. XML
- B. JSON
- C. Parquet
- D. CSV
Answer: D
NEW QUESTION 71
Which object allows you to limit the number of credits consumed within a Snowflake account?
Select one.
- A. Resource Monitor
- B. Credit Consumption Tracker
- C. Warehouse Limit Parameter
- D. Account usage Tracking
Answer: A
NEW QUESTION 72
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
- A. To accommodate more queries
- B. To accommodate a more complex workload
- C. To accommodate fluctuations in workload
- D. To accommodate more users
Answer: A
NEW QUESTION 73
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
- A. All of the above
- B. The Pipe load history is reset to empty
- C. Previously loaded files will be ignored
- D. The REFRESH parameter is set to TRUE
Answer: D
Explanation:
Explanation
NEW QUESTION 74
......
How to Prepare For SnowPro Core Certification
Preparation Guide for SnowPro Core Certification
Introduction for SnowPro Core Certification
SnowPro Core Certified individuals have demonstrated the knowledge necessary to apply specific core expertise in the marketplace with customers implementing and migrating to Snowflake. A SnowPro Core Certified individual has a thorough understanding of Snowflake as a cloud data warehouse and has the knowledge necessary to design, develop and manage secure, scalable Snowflake solutions to drive business objectives.
Our SNOWFLAKE SNOWPRO CORE practice exams and SNOWFLAKE SNOWPRO CORE practice tests are there to help you in memorizing and understanding all the topics. Use them to prepare for all of the exam requirements.
Snowflake is a cloud data platform built from the ground up for the cloud. Snowflake is built on a patented, multi-cluster, shared data architecture created for the cloud to revolutionize data warehousing, data lakes, data analytics and a host of other use cases.
Snowflake is a single platform comprised of storage, compute, and services layers that are logically integrated but scale infinitely and independent from one another.
Snowflake is a SaaS solution and is maintained by Snowflake and not the customer. Snowflake manages the services, compute, and storage layers. Data is only accessible via SQL in Snowflake. Snowflake can be deployed within AWS, Azure or GCP although not in customer controlled accounts.
The benefit of obtaining the SnowPro Core Certification Certification
Snowflake is a multi-tenant, secure, highly scalable and elastic data platform with full SQL support. It has built-in extensions for semi-structured and schema-less data and is offered as a pay-as-you-go service. There is no hardware and software to install, configure, or manage, no tuning knobs and no storage combing tasks. All ongoing maintenance, management, and tuning is handled by Snowflake as part of their SaaS services. Thus it is verymuch appreciated by organizations which are on the lookout for certified people.
Get SnowPro-Core Braindumps & SnowPro-Core Real Exam Questions: https://www.dumpsmaterials.com/SnowPro-Core-real-torrent.html
Snowflake SnowPro-Core Actual Questions and Braindumps: https://drive.google.com/open?id=1dvdP2CVLtu9mW4kFMWFS3y3KtSWW132n
