Use Real SnowPro-Core Dumps - Snowflake Correct Answers updated on 2021
SnowPro Core SnowPro-Core Exam Practice Dumps
NEW QUESTION 64
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 65
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
- A. False
- B. True
Answer: A
NEW QUESTION 66
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
- A. False
- B. True
Answer: A
NEW QUESTION 67
Which of the following statements are true of Snowflake releases: (Choose two.)
- A. They happen approximately weekly
- B. During a release, new customer requests/queries/connections transparently move over to the newer version
- C. They roll up and release approximately monthly, but customers can request early release application
- 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: B,D
NEW QUESTION 68
True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.
- A. False
- B. True
Answer: A
NEW QUESTION 69
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
- A. The validation_mode option is used when creating an Internal Stage
- B. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
- C. validation_mode=return_all_errors is a parameter of the copy command
- D. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
Answer: B,C
NEW QUESTION 70
Which statements are true of micro-partitions? (Choose two.)
- A. They are stored compressed only if COMPRESS=TRUE on Table
- B. They are approximately 16MB in size
- C. They are immutable
- D. They are only encrypted in the Enterprise edition and above
Answer: B,C
Explanation:
Explanation/Reference: https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1-
731ddc983c69
NEW QUESTION 71
True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).
- A. False
- B. True
Answer: A
NEW QUESTION 72
which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.
- A. Bulk copy from an External Stage
- B. Continuous load using Snowpipe REST API
- C. Bulk copy from an Internal Stage
- D. The Snowflake Web Interface (UT) data loading wizard
Answer: A,B,C,D
NEW QUESTION 73
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 74
True or False the longer the data retention period, the higher the resulting storage costs.
- A. True
- B. False
Answer: A
NEW QUESTION 75
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 76
True or False: A Virtual Warehouse can be resized while suspended.
- A. True
- B. False
Answer: A
NEW QUESTION 77
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. False
- B. True
Answer: A
NEW QUESTION 78
Which interfaces can be used to create and/or manage Virtual Warehouses?
- A. Data integration tools
- B. The Snowflake Web Interface (UI)
- C. All of the above
- D. SQL commands
Answer: D
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses.html
NEW QUESTION 79
How a Snowpipe charges calculated?
- A. Number of Pipes in account
- B. Total storage bucket size
- C. Per-second/per Warehouse size
- D. Per-second/per-core granularity
Answer: D
NEW QUESTION 80
Which item in the Data Warehouse migration process does not apply in Snowflake>
- A. Migrate Indexes
- B. Build the Data pipeline
- C. Migrate Schemas
- D. Migrate Users
Answer: A
NEW QUESTION 81
True or False: Once created, a micro-partition will never be changed.
- A. True
- B. False
Answer: A
NEW QUESTION 82
Which statements are true of micro-partitions?
Choose 2 answers
- A. They are stored compressed only if COMPRESS=TRUE on Table
- B. They are approximately 16MB in size
- C. They are Immutable
- D. They are only encrypted in the Enterprise edition and above
Answer: B,C
Explanation:
Reference:
731ddc983c69
NEW QUESTION 83
What is the minimum Snowflake edition that provides data sharing?
- A. Enterprise
- B. Standard
- C. Business Critical Edition
- D. Premier
Answer: A
NEW QUESTION 84
......
Get ready to pass the SnowPro-Core Exam right now using our SnowPro Core Exam Package: https://www.exams4sures.com/Snowflake/SnowPro-Core-practice-exam-dumps.html
SnowPro-Core Premium Files Test pdf - Free Dumps Collection: https://drive.google.com/open?id=1m3J2nZyeCvoyko_PJYQAoMqME-qcFrt5