2022 Updated Verified SnowPro-Core Q&As - Pass Guarantee or Full Refund
[Jan-2022] SnowPro-Core Certification with Actual Questions from PassCollection
What is the duration, language, and format of SnowPro Core Certification
- No negative marking for wrong answers
- Number of questions: 100
- Language of Exam: English, Japanese, Korean
- Passing grade: 70%
- Duration of Exam: 120 minutes
- Type of Questions: Multiple choice (MCQs), multiple answers
NEW QUESTION 17
Which formats are supported for unloading data from Snowflake?
Choose 2 answers
- A. Delimited (CSV, TSV, etc.)
- B. ORC
- C. Avro
- D. JSON
Answer: A,D
NEW QUESTION 18
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 19
Which of the following best describes where Snowflake's metadata is stored?
- A. within the drivers
- B. In the Cloud Services Layer
- C. Within the data files
- D. Inside the Virtual Warehouses
Answer: B
NEW QUESTION 20
When a pipe is recreated using the CREATE on REPLAC PIPE command:
Select one.
- A. The REFRESH parameter is set to TRUE
- B. All of the above
- C. Previously loaded files will be ignored
- D. The Pipe load history is reset to empty
Answer: D
NEW QUESTION 21
True or False: A Virtual Warehouse can be resized while suspended.
- A. True
- B. False
Answer: A
NEW QUESTION 22
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: C,D
NEW QUESTION 23
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: A
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION 24
True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.
- A. True
- B. False
Answer: B
NEW QUESTION 25
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.
- A. True
- B. False
Answer: A
NEW QUESTION 26
Which of the following roles is recommended to be used to create and manage users and roles?
- A. SYSADMIN
- B. SECURITYADMIN
- C. ACCOUNTADMIN
- D. PUBLIC
Answer: C
NEW QUESTION 27
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)
- A. ODBC
- B. JDBC
- C. Snowflake Web Interface (UI)
- D. Python
D18912E1457D5D1DDCBD40AB3BF70D5D - E. SnowSQL
Answer: A,B,C,D,E
NEW QUESTION 28
When should you consider disabling auto-suspend for a Virtual Warehouse? (Choose two.)
- A. When you do not want to have to manually turn on the Warehouse each time a user needs it
- B. When managing a steady workload
- C. When the compute must be available with no delay or lag time
- D. When users will be using compute at different times throughout a 24/7 period
Answer: B,C
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html
NEW QUESTION 29
Select the three types of tables that exist within Snowflake.
Choose 3 answers
- A. Permanent
- B. Temporary
- C. Translent
- D. Provisioned
Answer: A,B,C
NEW QUESTION 30
Which of the following roles is recommended to be used to create and manage users and roles?
- A. SYSADMIN
- B. SECURITYADMIN
- C. ACCOUNTADMIN
- D. PUBLIC
Answer: C
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
NEW QUESTION 31
Which of the following statements is true of data loading?
Select one.
- A. The "deal file size for loading is 16MB to match micro-partition size
- B. Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast
- C. Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism
Answer: C
Explanation:
Once loaded, there is no option to force a reload of an already loaded file
NEW QUESTION 32
......
Understanding functional and technical aspects of SnowPro Core Certification
The following will be discussed in SNOWFLAKE SNOWPRO CORE dumps:
- Query Performance & Analysis
- Caching
- Performance Management
- Semi Structured Data
- Unloading data from Snowflake to Internal Snowflake Storage
- Load Testing
- Account Management
- Unloading data from Snowflake to Local / Network
- Drive Data Unloading Considerations
- SQL optimization
- Unloading data from Snowflake to External Cloud Storage (S3,GCS,AZURE BLOB)
- Query Profile
- Clustering
- Native Syntax, Flattening Data
- Data Unloading
- Different Formats, Variant Table Type
SnowPro Core CertificationPath
This is a fundamental exam and gives credential of SnowPro Core Certified Professional.
SnowPro-Core Real Valid Brain Dumps With 164 Questions: https://www.passcollection.com/SnowPro-Core_real-exams.html
Updated SnowPro-Core Dumps PDF: https://drive.google.com/open?id=1xxPdcg3024tCzv6nd8_fsuHlI_hUaUCL
