[Jul-2024] Use Real SnowPro-Core Dumps Free Sample Questions and Practice Test Engine
Pass Snowflake SnowPro-Core exam - questions - convert Tets Engine to PDF
The SnowPro-Core exam is a rigorous and comprehensive program that requires candidates to demonstrate their knowledge and skills in using Snowflake's cloud-based data warehousing solution. SnowPro-Core exam consists of 90 multiple-choice questions that are designed to test a candidate's understanding of Snowflake's data warehousing solution. SnowPro-Core exam is timed and candidates have two hours to complete it.
NEW QUESTION # 182
Which interfaces can be used to create and/or manage Virtual Warehouses?
- A. The Snowflake Web Interface (UI)
- B. Data integration tools
- C. All of the above
- D. SQL commands
Answer: C
NEW QUESTION # 183
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
- A. Remove semi-structured data types
- B. Avoid using embedded characters such as commas for numeric data types
- C. Load files that are approximately 100-250 MB (or larger)
- D. Load files that are approximately 25 MB or smaller.
- E. Remove all dates and timestamps.
Answer: B,C
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html
NEW QUESTION # 184
What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?
- A. Enterprise Edition
- B. Business Critical Edition
- C. Virtual Private Snowflake Edition
- D. Standard Edition
Answer: B
Explanation:
The minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data is the Business Critical Edition. This edition offers enhanced security features necessary for compliance with regulations such as HIPAA and HITRUST CSF4.
NEW QUESTION # 185
Which function can be used with the copy into <location> statement to convent rows from a relational table to a single variant column, and to unload rows into a JSON file?
- A. TO VARIANT
- B. OBJECT_AS
- C. FLATTEN
- D. OBJECT_CONSTRUCT
Answer: A
Explanation:
The correct function to use with the COPY INTO <location> statement to convert rows from a relational table into a single variant column and to unload rows into a JSON file is TO VARIANT. The TO VARIANT function is used to explicitly convert a value of any supported data type into a VARIANT data type. This is particularly useful when needing to aggregate multiple columns or complex data structures into a single JSON-formatted string, which can then be unloaded into a file.
In the context of unloading data, the COPY INTO <location> statement combined with TO VARIANT enables the conversion of structured data from Snowflake tables into a semi-structured VARIANT format, typically JSON, which can then be efficiently exported and stored. This approach is often utilized for data integration scenarios, backups, or when data needs to be shared in a format that is easily consumed by various applications or services that support JSON.
References:
* Snowflake Documentation on Data Unloading: Unloading Data
* Snowflake Documentation on VARIANT Data Type: Working with JSON
NEW QUESTION # 186
What should be considered when deciding to use a secure view? (Select TWO).
- A. No details of the query execution plan will be available in the query profiler.
- B. Secure views do not take advantage of the same internal optimizations as standard views.
- C. The view definition of a secure view is still visible to users by way of the information schema.
- D. It is not possible to create secure materialized views.
- E. Once created there is no way to determine if a view is secure or not.
Answer: A,B
Explanation:
When deciding to use a secure view, several considerations come into play, especially concerning security and performance:
A: No details of the query execution plan will be available in the query profiler: Secure views are designed to prevent the exposure of the underlying data and the view definition to unauthorized users. Because of this, the detailed execution plans for queries against secure views are not available in the query profiler.
This is intended to protect sensitive data from being inferred through the execution plan.
C: Secure views do not take advantage of the same internal optimizations as standard views: Secure views, by their nature, limit some of the optimizations that can be applied compared to standard views. This is because they enforce row-level security and mask data, which can introduce additional processing overhead and limit the optimizer's ability to apply certain efficiencies that are available to standard views.
B: Once created, there is no way to determine if a view is secure or not is incorrect because metadata about whether a view is secure can be retrieved from the INFORMATION_SCHEMA views or by using the SHOW VIEWS command.
D: It is not possible to create secure materialized views is incorrect because the limitation is not on the security of the view but on the fact that Snowflake currently does not support materialized views with the same dynamic data masking and row-level security features as secure views.
E: The view definition of a secure view is still visible to users by way of the information schema is incorrect because secure views specifically hide the view definition from users who do not have the privilege to view it, ensuring that sensitive information in the definition is not exposed.
Reference: Snowflake Documentation on Secure Views
(https://docs.snowflake.com/en/user-guide/views-secure.html)
NEW QUESTION # 187
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
- A. Virtual Private Snowflake (VPS)
- B. Enterprise Edition
- C. Business Critical Edition
- D. Standard Edition
Answer: B
Explanation:
The minimum edition of Snowflake required to use a SCIM security integration is the Enterprise Edition.
SCIM integrations are used for automated management of user identities and groups, and this feature is available starting from the Enterprise Edition of Snowflake. References: [COF-C02] SnowPro Core Certification Exam Study Guide
NEW QUESTION # 188
A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?
A)
B)
C)
D)
- A. Option B
- B. Option D
- C. Option A
- D. Option C
Answer: C
NEW QUESTION # 189
Which data type can store more than one type of data structure?
- A. VARIANT
- B. JSON
- C. BINARY
- D. VARCHAR
Answer: A
NEW QUESTION # 190
How does the search optimization service help Snowflake users improve query performance?
- A. II maintains a persistent data structure that keeps track of the values of the table's columns m each of its micro-partitions.
- B. It keeps track of running queries and their results and saves those extra scans on the table.
- C. It scans the local disk cache to avoid scans on the tables used in the Query.
- D. It scans the micro-partitions based on the joins used in the queries and scans only join columns.
Answer: A
Explanation:
The search optimization service in Snowflake enhances query performance by maintaining a persistent data structure. This structure indexes the values of table columns across micro-partitions, allowing Snowflake to quickly identify which micro-partitions contain relevant data for a query. By efficiently narrowing down the search space, this service reduces the amount of data scanned during query execution, leading to faster response times and more efficient use of resources.References: Snowflake Documentation on Search Optimization Service
NEW QUESTION # 191
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
- A. The REFRESH parameter is set to TRUE
- B. All of the above
- C. The Pipe load history is reset to empty
- D. Previously loaded files will be ignored
Answer: C
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 # 192
Which command is used to unload data from a Snowflake table into a file in a stage?
- A. COPY INTO
- B. EXTRACT INTO
- C. GET
- D. WRITE
Answer: A
Explanation:
The COPY INTO command is used in Snowflake to unload data from a table into a file in a stage. This command allows for the export of data from Snowflake tables into flat files, which can then be used for further analysis, processing, or storage in external systems.
References:
* Snowflake Documentation on Unloading Data
* Snowflake SnowPro Core: Copy Into Command to Unload Rows to Files in Named Stage
NEW QUESTION # 193
When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
- A. 10-50 MB
- B. 1000-1500 MB
- C. 300-500 MB
- D. 100-250 MB
Answer: D
NEW QUESTION # 194
If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
- A. Stage definition
- B. Table definition
- C. COPY INTO TABLE statement
- D. Session level
Answer: C
NEW QUESTION # 195
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
- A. Databases
- B. Tables
- C. Users
- D. Internal Stages
Answer: A,B,C
NEW QUESTION # 196
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
- A. Task
- B. Stream
- C. External stage
- D. Pipe
Answer: D
Explanation:
Explanation
Snowpipe enables loading data from files as soon as they're available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
NEW QUESTION # 197
What is the recommended way to change the existing file format type in my format from CSV to JSON?
- A. CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;
- B. ALTER FILE FORMAT my format SWAP TYPE WITH JSON;
- C. ALTER FILE FORMAT my_format SET TYPE=JSON;
- D. REPLACE FILE FORMAT my format TYPE-JSON;
Answer: C
Explanation:
To change the existing file format type from CSV to JSON, the recommended way is to use the ALTER FILE FORMAT command with the SET TYPE=JSON clause. This alters the file format specification to use JSON instead of CSV. References: Based on my internal knowledge as of 2021.
NEW QUESTION # 198
Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).
- A. Data storage
- B. Metadata management
- C. Security
- D. Data visualization
- E. Query computation
Answer: B,C
NEW QUESTION # 199
......
Pass Your SnowPro-Core Exam Easily - Real SnowPro-Core Practice Dump Updated Jul 04, 2024: https://www.testkingit.com/Snowflake/latest-SnowPro-Core-exam-dumps.html
2024 Realistic Verified Free Snowflake SnowPro-Core Exam Questions: https://drive.google.com/open?id=1OdWm2lsMu64IGHs0Ng9JKVv_NVou5LUJ