[Mar-2023] Snowflake SnowPro-Core Dumps – Reduce Your Chance of Failure in SnowPro-Core Exam
To help you achieve your ultimate goal, we suggest the actual Snowflake SnowPro-Core dumps for your SnowPro Core Certification Exam exam preparation to use as your guideline.
NEW QUESTION 143
How often are encryption keys automatically rotated by Snowflake?
- A. 60 Days
- B. 365 Days
- C. 90 Days
- D. 30 Days
Answer: D
Explanation:
All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When Snowflake determines the retired key is no longer needed, the key is automatically destroyed.
https://docs.snowflake.com/en/user-guide/security-encryption-manage.html#:~:text=All%20Snowflake%2Dmanaged%20keys%20are,the%20key%20is%20automatically%20destroyed.
NEW QUESTION 144
A Virtual Warehouse's auto-suspend and auto-resume settings apply to:
- A. The primary cluster in the Virtual Warehouse
- B. The entire Virtual Warehouse
- C. The queries currently being run by the Virtual Warehouse
- D. The database the Virtual Warehouse resides in
Answer: B
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION 145
What is the purpose of multi-cluster virtual warehouses?
- A. To allow the warehouse to resize automatically
- B. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
- C. To create separate data warehouses to increase query optimization
- D. To eliminate or reduce Queuing of concurrent queries
Answer: D
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi%2Dcluster%20warehous
NEW QUESTION 146
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
- A. Customer-managed encryption keys through Tri-Secret Secure
- B. Object-level access control
- C. Column-level security to apply data masking policies to tables and views
- D. Automatic encryption of all data
- E. Up to 90 days of data recovery through Time Travel
Answer: B,D
Explanation:
https://docs.snowflake.com/en/user-guide/intro-editions.html
NEW QUESTION 147
The fail-safe retention period is how many days?
- A. 1 day
- B. 45 days
- C. 7 days
- D. 90 days
Answer: C
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
NEW QUESTION 148
Which formats are supported for unloading data from Snowflake?
Choose 2 answers
- A. Avro
- B. JSON
- C. Delimited (CSV, TSV, etc.)
- D. ORC
Answer: B,C
NEW QUESTION 149
Which statements are true of micro-partitions?
Choose 2 answers
- A. They are only encrypted in the Enterprise edition and above
- B. They are Immutable
- C. They are approximately 16MB in size
- D. They are stored compressed only if COMPRESS=TRUE on Table
Answer: B,C
Explanation:
Reference:
731ddc983c69
NEW QUESTION 150
Which of the following roles is recommended to be used to create and manage users and roles?
- A. SECURITYADMIN
- B. ACCOUNTADMIN
- C. SYSADMIN
- D. PUBLIC
Answer: B
NEW QUESTION 151
True or False: A single database can exist in more than one Snowflake account.
- A. True
- B. False
Answer: B
NEW QUESTION 152
True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.
- A. True
- B. False
Answer: A
NEW QUESTION 153
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
- A. 12 hours
- B. 3 Hours
- C. 24 hours
- D. 1 Hour
Answer: C
Explanation:
Explanation/Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse
NEW QUESTION 154
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 exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time 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 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
Answer: A,B
NEW QUESTION 155
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
- A. True
- B. False
Answer: B
NEW QUESTION 156
Which of the following objects is not covered by Time Travel?
- A. Databases
- B. Stages
- C. Tables
- D. Schemas
Answer: B
NEW QUESTION 157
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
- A. Set the Warehouse type to "Auto"
- B. Set the Minimum Clusters and Maximum Clusters settings to the different values
- C. Set the Minimum Clusters and Maximum Clusters settings to the same value
- D. Configure the Maximum Clusters setting to "Auto-Scale"
Answer: B
Explanation:
Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse
NEW QUESTION 158
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: B
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history
"When a pipe is recreated, the load history is dropped."
NEW QUESTION 159
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?
- A. Create a database and grant all permissions to teammates
- B. Create a zero-copy clone of the worksheet and grant permissions to teammates
- C. Create a private Data Exchange so that any teammate can use the worksheet
- D. Share the worksheet with teammates within Snowsight
Answer: D
NEW QUESTION 160
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
- A. Optimized
- B. Custom
- C. Economy
- D. Standard
Answer: C,D
Explanation:
Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance
NEW QUESTION 161
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.
- A. True
- B. False
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/ui-worksheet.html
NEW QUESTION 162
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
- A. The Pipe load history is reset to empty
- B. All of the above
- C. Previously loaded files will be ignored
- D. The REFRESH parameter is set to TRUE
Answer: D
Explanation:
Explanation
NEW QUESTION 163
True or False: Snowflake charges additional fees to Data Providers for each Share they create.
- A. True
- B. False
Answer: A
Explanation:
Explanation/Reference: https://1amiydhcmj36tz3733v94f15-wpengine.netdna-ssl.com/wp-content/uploads/2017/08/ Enabling-new-products-and-services-with-Snowflake-Data-Sharing.pdf
NEW QUESTION 164
Network policies can be set at which Snowflake levels? (Choose two.)
- A. Account
- B. Database
- C. User
- D. Schema
- E. Role
- F. Tables
Answer: A,C
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/network-policies.html#creating-network-policies
NEW QUESTION 165
......
100% Free SnowPro-Core Demo-Trial [Pdf], get it now: https://drive.google.com/open?id=1zwPcPVyFfmNNPZy94FRkQWl2k2pqhFRS
Accurate & Verified Answers As Seen in the Real Exam here: https://www.examprepaway.com/Snowflake/braindumps.SnowPro-Core.ete.file.html