Latest [Sep 12, 2021] Snowflake SnowPro-Core Exam Practice Test To Gain Brilliante Result
Take a Leap Forward in Your Career by Earning Snowflake SnowPro-Core
NEW QUESTION 73
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 74
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.
- A. False
- B. True
Answer: A
Explanation:
Explanation
NEW QUESTION 75
True or False: Once created, a micro-partition will never be changed.
- A. True
- B. False
Answer: A
NEW QUESTION 76
Which of the following statements are true of Snowflake data loading?
Choose 3 answers
- A. It is recommended to do frequent, single row DMLS
- B. VARIANT "nut" values are not the same as SQL Null values
- C. It is recommended to use staging tables to manage MERGE statements
- D. It is recommended to validate the data before loading into the Snowflake target table
Answer: B,C,D
NEW QUESTION 77
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
- A. 1 Hour
- B. 3 Hours
- C. 24 hours
- D. 12 hours
Answer: C
Explanation:
Explanation/Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse
NEW QUESTION 78
True or False: You can resize a Virtual Warehouse while queries are running.
- A. True
- B. False
Answer: A
NEW QUESTION 79
Data storage for individual tables can be monitored using which commands and/or object(s)?
Choose 2 answers
- A. Information Schema -> TASLE_HISTORY
- B. SHOW TABLES;
- C. Information Schema -> TABLE_STORAGE_METRICS
- D. SHOW STORAGE BY TABLE;
Answer: A,B
NEW QUESTION 80
When creating a user it is advisable sable to:
Choose 2 answers
- A. Force an immediate password change
- B. Set the users access to expire within a specified timeframe
- C. Set the user to be initially disabled
- D. Set a default role for the user
- E. Set the number of minutes to unlock to 15 minutes
Answer: A,D
NEW QUESTION 81
Select the different types of Internal Stages: (Choose three.)
- A. User Stage
- B. Table Stage
- C. Schema Stage
- D. Named Stage
Answer: A,B,D
NEW QUESTION 82
Which of the following are true of multi-cluster Warehouses? Select all that apply below.
- A. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
- B. A multi-cluster Warehouse can add clusters automatically based on query activity
- C. A multi-cluster Warehouse can scale down when query activity slows
- D. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it
Answer: A,B,C,D
NEW QUESTION 83
Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:
- A. Scaling out
- B. Scaling max
- C. Scaling Up
- D. Scaling rhythmically
Answer: A
NEW QUESTION 84
True or False: When you create a custom role, it is a practice to immediately grant that role to ACCOUNTADMIN.
- A. False
- B. True
Answer: A
NEW QUESTION 85
What is the most granular object that the Time Travel retention can be defined on?
Select one.
- A. Schema
- B. Account
- C. Table
- D. Database
Answer: C
NEW QUESTION 86
What is the lowest Snowflake edition that offers Time Travel up to 90 days.
- A. Enterprise Edition
- B. standard Edition
- C. Business Critical Edition
- D. Premier Edition
Answer: A
NEW QUESTION 87
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.
- A. False
- B. True
Answer: A
NEW QUESTION 88
What is the most granular object that the Time Travel retention period can be defined on?
Select one.
- A. Schema
- B. Table
- C. Account
- D. Database
Answer: C
NEW QUESTION 89
Account-level storage usage can be monitored via:
- A. The snowflake wet Interface (UI) in the Databases section.
- B. The Account usage Schema - > ACCOUNT_USAGE_METRICS View
- C. The Information Schema -> ACCOUNT_USAGE_HISTORY View
- D. The Snowflake web interface (UI) in the Account -> Billing a usage section
Answer: D
NEW QUESTION 90
When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers
- A. When the compute must be available with no delay or lag time
- B. When managing a steady workload
- 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: B,D
NEW QUESTION 91
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 92
Which of the following statements is true of data loading?
Select one.
- A. Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism
- B. The "deal file size for loading is 16MB to match micro-partition size
- C. Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast
Answer: A
Explanation:
Once loaded, there is no option to force a reload of an already loaded file
NEW QUESTION 93
True or False: Pipes can be suspended and resumed.
- A. False
- B. True
Answer: A
NEW QUESTION 94
Which of the following is true of Snowpipe via REST API?
Choose 2 answers
- A. All COPY INTO options are available fluting pipe creation
- B. Snowpipe keeps track of which files it has loaded
- C. Snowflake automatically manages the compute required to execute the Pipe's copy into commands
- D. you can only use it on internal Stages
Answer: B,C
NEW QUESTION 95
True or False: The user has to specify which cluster a query will run on in a multi-cluster Warehouse.
- A. True
- B. False
Answer: A
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
NEW QUESTION 96
......
Authentic Best resources for SnowPro-Core Online Practice Exam: https://www.vceengine.com/SnowPro-Core-vce-test-engine.html
Updates Up to 365 days On Developing SnowPro-Core Braindumps: https://drive.google.com/open?id=1oTiZf2BtRQaYszsUjPe7I60FjAW66VFD
