[Sep-2021] Updated SnowPro Core SnowPro-Core Exam Questions BUNDLE PACK
Master The Snowflake Content SnowPro-Core EXAM DUMPS WITH GUARANTEED SUCCESS!
NEW QUESTION 22
What is the minimum duration charged when starting a virtual warehouse?
- A. 1 minute
- B. 1 hour
- C. 1 day
- D. 1 second
Answer: A
NEW QUESTION 23
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
- A. True
- B. False
Answer: A
NEW QUESTION 24
True or False: You can define multiple columns within a clustering key on a table.
- A. True
- B. False
Answer: A
NEW QUESTION 25
What privileges are required to create a task?
- A. Tasks are created at the Application level and can only be created by the Account Admin role.
- B. The role must have access to the target schema and the create task privilege on the schema itself.
- C. The global privilege create task is required to create a new task.
- D. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
Answer: C
NEW QUESTION 26
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
- A. Standard
- B. Premier
- C. Business Critical Edition
- D. Enterprise
Answer: C
NEW QUESTION 27
True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.
- A. True
- B. False
Answer: A
NEW QUESTION 28
When a pipe is recreated using the CREATE on REPLAC PIPE command:
Select one.
- A. The Pipe load history is reset to empty
- B. The REFRESH parameter is set to TRUE
- C. Previously loaded files will be ignored
- D. All of the above
Answer: A
NEW QUESTION 29
Fail-safe is unavailable on which table types?
- A. Translent
- B. Provisional
- C. Temporary
- D. Permanent
Answer: A,C
NEW QUESTION 30
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
- A. Custom
- B. Optimized
- C. Standard
- D. Economy
Answer: C,D
Explanation:
Explanation/Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance
NEW QUESTION 31
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:
- A. Performance
- B. Concurrency
Answer: B
NEW QUESTION 32
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.
- A. False
- B. True
Answer: A
NEW QUESTION 33
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
- A. True
- B. False
Answer: A
NEW QUESTION 34
When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers
- A. When managing a steady workload
- B. When the compute must be available with no delay or lag time
- C. When users will be using compute at different times throughout a 24/7 period
- D. When you don't want to have to manually turn on the Warehouse each time a user needs it
Answer: A,B
NEW QUESTION 35
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers
- A. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period
- B. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous
- C. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed
- D. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period
Answer: A,C
NEW QUESTION 36
Which of the following roles is recommended to be used to create and manage users and roles?
- A. SYSADMIN
- B. PUBLIC
- C. ACCOUNTADMIN
- D. SECURITYADMIN
Answer: C
NEW QUESTION 37
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers
- A. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed
- B. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period
- C. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous
- D. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period
Answer: C,D
NEW QUESTION 38
Which of the following statements about data sharing are true?
choose 2 answers
- A. Reader Accounts are created and funded by Data Prowlers
- B. Shared databases are read-only
- C. All database objects can be included In a shared database
- D. New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts
Answer: A,B
NEW QUESTION 39
Which type of table corresponds to a single Snowflake session?
- A. Provisional
- B. Temporary
- C. Transient
- D. Permanent
Answer: B
NEW QUESTION 40
As a best practice, clustering keys should only be defined on tables of which minimum size?
- A. Multi-Terabyte (TB) Range
- B. Multi-Megabyte (MB) Range
- C. Multi-Kilobyte (KB) Range
- D. Multi-Gigabyte (GB) Range
Answer: A
NEW QUESTION 41
......
Pass Snowflake SnowPro-Core Exam – Experts Are Here To Help You: https://www.prep4sureexam.com/SnowPro-Core-dumps-torrent.html
Get Latest SnowPro Core SnowPro-Core Practice Test For Quick Preparation: https://drive.google.com/open?id=1APBrpNR4hRiQn61_fmDOdrP-jzppTaj8