[Oct 10, 2021] Updates Up to 365 days On Valid SnowPro-Core Braindumps
Best QualitySnowPro-Core Exam Questions Snowflake Test To Gain Brilliante Result
NEW QUESTION 72
True or False: It is possible to load data into Snowflake without creating a named File Format object.
- A. True
- B. False
Answer: A
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html
NEW QUESTION 73
A Virtual Warehouse's auto-suspend and auto-resume settings apply to:
- A. The queries currently being run by the Virtual Warehouse
- B. The primary duster in the virtual warehouse
- C. The entire Virtual Warehouse
- D. The database the Virtual Warehouse resides in
Answer: C
NEW QUESTION 74
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 75
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)
- A. The "24 hour" timer on the precomputed results gets renewed every time the exact query is executed
- B. The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time 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 24 hour period
- D. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within previous 24 hour period
Answer: B,C
NEW QUESTION 76
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 77
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION 78
Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:
- A. Scaling up
- B. Scaling max
- C. Scaling out
- D. Scaling rhythmically
Answer: A
NEW QUESTION 79
Snowflake is designed for which type of workloads? (Choose two.)
- A. OLTP (Transactional) workloads
- B. On-premise workloads
- C. Concurrent workloads
- D. OLAP (Analytics) workloads
Answer: A,D
NEW QUESTION 80
Which of the following statements would be used to export/unload data from Snowflake?
- A. INSERT INTO @stage
- B. COPY INTO @stage
- C. EXPORT TO @stage
- D. EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);
Answer: B
NEW QUESTION 81
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers
- A. Temporary Tables
- B. Transient Tables
- C. Provisional Tables
- D. Permanent Tables
Answer: A,B
NEW QUESTION 82
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers
- A. Temporary Tables
- B. Translent Tables
- C. Provisional Tables
- D. Permanent Tables
Answer: A,B
NEW QUESTION 83
Which of the following statements are true about Schemas in Snowflake? (Choose two.)
- A. Each Schema is contained within a Warehouse
- B. A Schema may contain one or more Databases
- C. A Schema is a logical grouping of Database Objects
- D. A Database may contain one or more Schemas
Answer: C,D
NEW QUESTION 84
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
- A. Set the Minimum Clusters and Maximum Clusters settings to the different values
- B. Configure the Maximum Clusters setting to "Auto-Scale"
- C. Set the Warehouse type to "Auto"
- D. Set the Minimum Clusters and Maximum Clusters settings to the same value
Answer: A
NEW QUESTION 85
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
NEW QUESTION 86
True or False: A Virtual Warehouse can be resized while suspended.
- A. True
- B. False
Answer: A
NEW QUESTION 87
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
- A. The REFRESH parameter is set to TRUE
- B. Previously loaded files will be ignored
- C. The Pipe load history is reset to empty
- D. All of the above
Answer: A
Explanation:
Explanation
NEW QUESTION 88
True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.
- A. False
- B. True
Answer: A
NEW QUESTION 89
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 90
......
Focus on SnowPro-Core All-in-One Exam Guide For Quick Preparation: https://www.vce4dumps.com/SnowPro-Core-valid-torrent.html
Tested Material Used To SnowPro-Core: https://drive.google.com/open?id=1_d696RPAcTnINXUjFeg-0zcxH2i6ROQY