[Nov 04, 2021] Get New SnowPro-Core Certification Practice Test Questions Exam Dumps
Real SnowPro-Core Exam Dumps Questions Valid SnowPro-Core Dumps PDF
How to book the SnowPro Core Certification
To apply for the SnowPro Core Certification, You have to follow these steps:
- Click Add to Cart and complete your registration/purchase
- Click Enroll and log in to your Snowpro account
- Attempt the exam whenever you want
NEW QUESTION 41
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 42
Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)
- A. Compute can be scaled up or down without the requirement to add more storage
- B. Storage expands without the requirement to add more compute
- C. Multiple compute clusters can access stored data without contention
- D. Growth of storage and compute are tightly coupled together
Answer: D
Explanation:
Explanation/Reference: https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehouse- doesnt-separate-storage-and-compute-65d2dffd450f
NEW QUESTION 43
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 44
Which of the following statements are true of Snowflake data loading?
Choose 3 answers
- A. It is recommended to validate the data before loading into the Snowflake target table
- B. It is recommended to use staging tables to manage MERGE statements
- C. It is recommended to do frequent, single row DMLS
- D. VARIANT "nut" values are not the same as SQL Null values
Answer: A,B,D
NEW QUESTION 45
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 46
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
- A. # of clusters for the Warehouse
- B. Amount of data processed
- C. Warehouse size
- D. Number of users
Answer: B,C
NEW QUESTION 47
What is the minimum duration charged when starting a virtual warehouse?
- A. 1 hour
- B. 1 minute
- C. 1 second
- D. 1 day
Answer: B
NEW QUESTION 48
Which of the following are main sections of the top navigation of the Snowflake Web Interface (UI)? (Choose three.)
- A. Warehouses
- B. Worksheets
- C. Databases
- D. Tables
Answer: A,B,C
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/snowflake-manager.html
NEW QUESTION 49
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: B
NEW QUESTION 50
True or False: Pipes can be suspended and resumed.
- A. True
- B. False
Answer: B
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
NEW QUESTION 51
Which of the following statements is true of Snowflake micro-partitioning?
- A. Micro-partitioning: requires a partitioning schema to be defined up front
- B. Micro-partitioning has been known to introduce data skew
- C. Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
- D. Micro-partitioning can be disabled within a Snowflake account
Answer: C
NEW QUESTION 52
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
- A. Is available to all Snowflake Editions
- B. Is activated using an "ALTER DATABASE" command
- C. Is only available to customers with Business Critical Edition
- D. Restricts or enables access to specific IP addresses
Answer: A,D
NEW QUESTION 53
Which of the following are options when creating a Virtual Warehouse?
- A. User count
- B. Auto-resume
- C. Local SSD size
- D. Auto-suspend
Answer: B,D
NEW QUESTION 54
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
- A. Custom
- B. Standard
- C. Optimized
- D. Economy
Answer: B,D
NEW QUESTION 55
True or False: You can query the files in an External Stage directly without having to load the data into a table.
- A. True
- B. False
Answer: A
NEW QUESTION 56
Which statement best describes Snowflake tables?
- A. Snowflake tables are logical representations of underlying physical data
- B. Snowflake tables ate the physical instantiation of data loaded Into Snowflake
- C. Snowflake tables are owned by a user
- D. Snowflake tables require that clustering keys be defined to perform optimally
Answer: A
NEW QUESTION 57
On which of the following cloud platform can a Snowflake account be hosted?
Choose 2 answers
- A. Microsoft Azure Cloud
- B. Amazon Web Services
- C. Oracle Cloud
- D. Private Virtual Cloud
Answer: A,B
NEW QUESTION 58
......
SnowPro-Core Exam Dumps - PDF Questions and Testing Engine: https://www.dumpsquestion.com/SnowPro-Core-exam-dumps-collection.html
Latest SnowPro-Core Exam Dumps for Pass Guaranteed: https://drive.google.com/open?id=156ijmaX5saRXgKVJVyyq-sQUA6EuH0Ft