Updated Oct 11, 2022 Verified Pass SnowPro-Core Exam in First Attempt Guaranteed
Free SnowPro-Core Sample Questions and 100% Cover Real Exam Questions (Updated 255 Questions)
Understanding functional and technical aspects of SnowPro Core Certification
The following will be discussed in SNOWFLAKE SNOWPRO CORE exam dumps:
- Load Testing
- Unloading data from Snowflake to Local / Network
- Drive Data Unloading Considerations
- Account Management
- Different Formats, Variant Table Type
- Data Unloading
- Performance Management
- SQL optimization
- Clustering
- Query Performance & Analysis
- Unloading data from Snowflake to Internal Snowflake Storage
- Caching
Understanding functional and technical aspects of Data Quality 10 Developer, Professional Certification
The following will be discussed in SNOWFLAKE SNOWPRO CORE exam dumps:
- Cloud Services
- Partner Connector Ecosystem
- Connector Ecosystem
- Database Storage
- Snowflake Release
- Snowflake Regions
- Data Lifecycle
- Data Protection
- Query Processing
- Snowflake WebUI
- Snowflake Architecture
NEW QUESTION 139
Which of the following statements would be used to export/unload data from Snowflake?
- A. EXPORT TO @stage
- B. COPY INTO @slage
- C. EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);
- D. INSERT INTO @stage
Answer: B
NEW QUESTION 140
True or False: Snowflake charges a premium for storing semi-structured data.
- A. False
- B. True
Answer: A
NEW QUESTION 141
What are value types that a VARIANT column can store? (Select TWO)
- A. OBJECT
- B. ARRAY
- C. STRUCT
- D. CLOB
- E. BINARY
Answer: A,B
Explanation:
Characteristics of a VARIANT
A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%20of%20a%20VARIANT,a%20VARIANT%20is%2016%20MB.
NEW QUESTION 142
What is the minimum Snowflake edition that provides data sharing?
- A. Premier
- B. Standard
- C. Business Critical Edition
- D. Enterprise
Answer: D
NEW QUESTION 143
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 144
What are ways to create and manage data shares in Snowflake? (Select TWO)
- A. Through the enable__share=true parameter
- B. Using the CREATE SHARE AS SELECT * TABLE command
- C. Through the Snowflake web interface (Ul)
- D. Through the DATA_SHARE=TRUE parameter
- E. Through SQL commands
Answer: A,E
NEW QUESTION 145
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 146
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 147
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
- A. True
- B. False
Answer: A
Explanation:
Explanation
Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.
NEW QUESTION 148
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
- A. Micro-partitions have been reclustered since the query was last run
- B. The query has been run within 24 hours of the previously-run query
- C. The user has the appropriate privileges on the objects associated with the query
- D. The query includes a User Defined Function (UDF)
- E. The new query is run using the same virtual warehouse as the previous query
Answer: B,C
NEW QUESTION 149
True or False: The COPY command must specify a File Format in order to execute.
- A. True
- B. False
Answer: A
Explanation:
Explanation/Reference: https://interworks.com/blog/hcalder/2018/07/26/the-basics-of-loading-data-into-snowflake/
NEW QUESTION 150
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
- A. The use of warehouse auto scaling
- B. Use of multi-clustered warehouses
- C. The ability to scale up warehouses
- D. The use of warehouse indexing
- E. The ability to resize warehouses
Answer: A,B
NEW QUESTION 151
Which cache type is used to cache data output from SQL queries?
- A. Result cache
- B. Local file cache
- C. Remote cache
- D. Metadata cache
Answer: A
Explanation:
https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse
NEW QUESTION 152
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
- A. Premier
- B. Standard
- C. Business Critical Edition
- D. Enterprise
Answer: C
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
NEW QUESTION 153
Which interfaces can be used to create and/or manage Virtual Warehouses?
- A. SQL commands
- B. The Snowflake Web Interface (UI)
- C. Data integration tools
- D. All of the above
Answer: A
NEW QUESTION 154
What SQL command would be used to view all roles that were granted to user.1?
- A. show grants of user USER1;
- B. show grants on user USER1;
- C. describe user USER1;
- D. show grants to user USER1;
Answer: D
NEW QUESTION 155
Which statements are true of micro-partitions? (Choose two.)
- A. They are approximately 16MB in size
- B. They are immutable
- C. They are stored compressed only if COMPRESS=TRUE on Table
- D. They are only encrypted in the Enterprise edition and above
Answer: A,B
Explanation:
Explanation/Reference: https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1-
731ddc983c69
NEW QUESTION 156
True or False: Snowflake charges additional fees to Data providers for each share they create.
- A. False
- B. True
Answer: A
Explanation:
"The costs for sharing data with Snowflake are minimal and straightforward. Data providers simply pay Snowflake for the data they store, and data consumers pay for the compute resources their queries consume."
NEW QUESTION 157
Snowflake is designed for which type of workloads? (Choose two.)
- A. Concurrent workloads
- B. OLTP (Transactional) workloads
- C. On-premise workloads
- D. OLAP (Analytics) workloads
Answer: B,D
Explanation:
Explanation/Reference: https://blog.couchbase.com/its-the-workload-stupid/
NEW QUESTION 158
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
- A. External bytes scanned
- B. Percentage scanned from cache
- C. Bytes sent over the network
- D. Bytes scanned
- E. Number of partitions scanned
Answer: D,E
NEW QUESTION 159
The FLATEEN function is used to query which type of data in Snowflake?
- A. None of the above
- B. Semi-structured data
- C. Both of the above
- D. Structured data
Answer: B
Explanation:
Reference:
FLATTEN is used to unnest semi-structured data. Don't see an application for structured data as by definition it shouldn't be nested.
NEW QUESTION 160
True or False: Fail-safe can be disabled within a Snowflake account.
- A. True
- B. False
Answer: A
NEW QUESTION 161
......
Download Real Snowflake SnowPro-Core Exam Dumps Test Engine Exam Questions: https://pass4sure.itexamdownload.com/SnowPro-Core-valid-questions.html