SnowPro-Core Practice Snowflake Verified Answers - Pass Your Exams For Sure! [2023]
Valid Way To Pass SnowPro Core's SnowPro-Core Exam
Understanding functional and technical aspects of SnowPro Core Certification
The following will be discussed in SNOWFLAKE SNOWPRO CORE exam dumps:
- Account Management
- Semi Structured Data
- Query Profile
- Load Testing
- Different Formats, Variant Table Type
- Unloading data from Snowflake to External Cloud Storage (S3,GCS,AZURE BLOB)
- Native Syntax, Flattening Data
- Clustering
- Unloading data from Snowflake to Local / Network
NEW QUESTION 245
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?
- A. It removes the outer array structure and loads the records into separate table rows,
- B. It removes the last element of the outer array.
- C. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
- D. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records
Answer: A
Explanation:
Data Size Limitations
The VARIANT data type imposes a 16 MB size limit on individual rows.
For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents. The JSON output from some software is composed of a single huge array containing multiple records. There is no need to separate the documents with line breaks or commas, though both are supported.
If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format option for the COPY INTO <table> command to remove the outer array structure and load the records into separate table rows:
copy into <table>
from @~/<file>.json
file_format = (type = 'JSON' strip_outer_array = true);
https://docs.snowflake.com/en/user-guide/semistructured-considerations.html
NEW QUESTION 246
Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)
- A. Running EXPLAIN and SHOW commands
- B. Cloning a database
- C. Running a custom query
- D. Caching query results
- E. Running COPY commands
Answer: C,D
NEW QUESTION 247
When loading data into Snowflake, how should the data be organized?
- A. Into files of maximum size of 4 GB of compressed data per file
- B. Into files of maximum size of 1 GB of compressed data per file
- C. Into single files with 100-250 MB of compressed data per file
- D. Into single files with 1-100 MB of compressed data per file
Answer: C
NEW QUESTION 248
Which of the following is true of Snowpipe via REST API?
Choose 2 answers
- A. you can only use it on internal Stages
- 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. All COPY INTO options are available fluting pipe creation
Answer: B,C
NEW QUESTION 249
What is the purpose of an External Function?
- A. To run a function in another Snowflake database
- B. To share data in Snowflake with external parties
- C. To ingest data from on-premises data sources
- D. To call code that executes outside of Snowflake
Answer: D
Explanation:
https://docs.snowflake.com/en/sql-reference/external-functions.html
NEW QUESTION 250
Which of the following DML commands isn't supported by Snowflake?
- A. TRUNCATE TABLE
- B. UPDATE
- C. MERGE
- D. UPSERT
Answer: D
NEW QUESTION 251
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.
- A. False
- B. True
Answer: A
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/jdbc.html
Snowflake provides a JDBC type 4 driver that supports core JDBC functionality. The JDBC driver must be installed in a 64-bit environment and requires Java 1.8 (or higher). The driver can be used with most client tools/applications that support JDBC for connecting to a database server.
NEW QUESTION 252
What is a responsibility of Snowflake's virtual warehouses?
- A. Query parsing and optimization
- B. Management of the storage layer
- C. Infrastructure management
- D. Query execution
- E. Metadata management
Answer: D
NEW QUESTION 253
True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.
- A. True
- B. False
Answer: A
NEW QUESTION 254
True or False: Fail-safe can be disabled within a Snowflake account.
- A. False
- B. True
Answer: A
NEW QUESTION 255
True or False: During data unloading, only JSON and CSV files can be compressed.
- A. False
- B. True
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html
NEW QUESTION 256
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
- A. Streams
- B. Pipes
- C. Tasks
- D. Procedures
Answer: A
Explanation:
https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%20a%20Snowflake,as%20metadata%20about%20each%20change.
NEW QUESTION 257
Which of the following best describes where Snowflake's metadata is stored?
- A. Within the data files
- B. In the Cloud Services Layer
- C. within the drivers
- D. Inside the Virtual Warehouses
Answer: B
NEW QUESTION 258
Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)?
Choose 2 answers
- A. Python
- B. JavaScript
- C. SQL
- D. Java
Answer: B,C
NEW QUESTION 259
In which layer of its architecture does Snowflake store its metadata statistics?
Select one.
- A. Database Layer
- B. Cloud Service Layer
- C. Compute Layer
- D. Storage Layer
Answer: B
NEW QUESTION 260
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 261
Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously?
Choose 3 answers
- A. COPY
- B. UPDATE
- C. SUM(<< column value >>)
- D. MIN(< < column value>>)
Answer: A,B,C
NEW QUESTION 262
Which feature is only available in the Enterprise or higher editions of Snowflake?
- A. SOC 2 type II certification
- B. Object-level access control
- C. Column-level security
- D. Multi-factor Authentication (MFA)
Answer: C
Explanation:
https://docs.snowflake.com/en/user-guide/intro-editions.html
NEW QUESTION 263
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
- A. OAuth
- B. Key-pair authentication
- C. OCSP authentication
- D. TLS 1.2
- E. Federated authentication
- F. SCIM
Answer: A,B,E
NEW QUESTION 264
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. Bulk copy from an Internal Stage
- C. The Snowflake Web Interface (UT) data loading wizard
- D. Continuous load using Snowpipe REST API
Answer: A,C,D
NEW QUESTION 265
What is the recommended Snowflake data type to store semi-structured data like JSON?
- A. VARIANT
- B. LOB
- C. VARCHAR
- D. RAW
Answer: A
NEW QUESTION 266
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
- A. True
- B. False
Answer: A
Explanation:
Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.
NEW QUESTION 267
......
The benefit of obtaining the SnowPro Core Certification Certification
Snowflake is a multi-tenant, secure, highly scalable and elastic data platform with full SQL support. It has built-in extensions for semi-structured and schema-less data and is offered as a pay-as-you-go service. There is no hardware and software to install, configure, or manage, no tuning knobs and no storage combing tasks. All ongoing maintenance, management, and tuning is handled by Snowflake as part of their SaaS services. Thus it is verymuch appreciated by organizations which are on the lookout for certified people.
Snowflake SnowPro-Core Pre-Exam Practice Tests | PracticeVCE: https://vce4exams.practicevce.com/Snowflake/SnowPro-Core-practice-exam-dumps.html