Free SnowPro-Core Braindumps Download Updated on Mar 09, 2023 with 415 Questions
Snowflake SnowPro-Core Exam Practice Test Questions
Who should take the SnowPro Core Certification
This exam's objective is to measure an individual's knowledge and ability to use Snowflake based data warehouse solution. To earn this certification, you must pass the SnowPro Core Certification exam. The exam format consists of multiple select, multiple choice, True/False, fill-in the blank and terminology matching questions. The exam has no mandatory prerequisites and is administered by our third-party proctor.
A Snowflake SnowPro Core Certificate individual has a thorough understanding of Snowflake as a cloud data warehouse and has the knowledge necessary to design, develop and manage secure, scalable Snowflake solutions to drive business objectives. For this, you can use our SNOWFLAKE SNOWPRO CORE practice exam and SNOWFLAKE SNOWPRO CORE practice exams to ensure that you are ready for the exam.
NEW QUESTION 233
Which of the following is a data tokenization integration partner?
- A. Protegrity
- B. Tableau
- C. DBeaver
- D. SAP
Answer: A
NEW QUESTION 234
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers
- A. Permanent Tables
- B. Temporary Tables
- C. Provisional Tables
- D. Translent Tables
Answer: B,D
NEW QUESTION 235
Which statement best describes '' clustering''?
- A. Clustering represents the way data is grouped together and stored within snowflake's micro-partitions
- B. The clustering key must be included on the COPV command when loading data into Snowflake.
- C. The database administrator must define the clustering methodology for each Snowflake table.
- D. Clustering can be disabled within a Snowflake account.
Answer: A
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html
NEW QUESTION 236
On which of the following cloud platform can a Snowflake account be hosted?
Choose 2 answers
- A. Microsoft Azure Cloud
- B. Oracle Cloud
- C. Private Virtual Cloud
- D. Amazon Web Services
Answer: A,D
NEW QUESTION 237
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 trailing spaces in the last element of the outer array and loads the records into separate table columns
- B. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records
- C. It removes the outer array structure and loads the records into separate table rows,
- D. It removes the last element of the outer array.
Answer: C
Explanation:
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 238
How would a user run a multi-cluster warehouse in maximized mode?
- A. Turn on the additional clusters manually after starting the warehouse.
- B. Set the minimum clusters and maximum clusters settings to different values.
- C. Set the minimum Clusters and maximum Clusters settings to the same value.
- D. Configure the maximum clusters setting to "Maximum."
Answer: B
NEW QUESTION 239
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. Previously loaded files will be ignored
- D. The Pipe load history is reset to empty
Answer: D
Explanation:
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 240
When is the result set cache no longer available? (Select TWO)
- A. When the warehouse used to execute the query is suspended
- B. When another user executes the query
- C. When another warehouse is used to execute the query
- D. When the underlying data has changed
- E. When it has been 24 hours since the last query
Answer: D,E
NEW QUESTION 241
For a multi-cluster Warehouse, the number of credits billed is calculated on:
Select one.
- A. The number of queries that ran using the Warehouse.
- B. The number of users who accessed the Warehouse.
- C. The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.
- D. The size of the Warehouse and the number of clusters that ran within a given time period.
Answer: D
NEW QUESTION 242
What is the purpose of an External Function?
- A. To call code that executes outside of Snowflake
- B. To ingest data from on-premises data sources
- C. To share data in Snowflake with external parties
- D. To run a function in another Snowflake database
Answer: A
Explanation:
https://docs.snowflake.com/en/sql-reference/external-functions.html
NEW QUESTION 243
What command is used to load files into an Internal Stage within Snowflake? Select one.
- A. TRANSFER
- B. INSERT
- C. PUT
- D. COPY INTO
Answer: C
Explanation:
You must specify an internal stage in the PUT command when uploading files to Snowflake. You must specify the same stage in the COPY INTO <table> command when loading data into a table from the staged files.
NEW QUESTION 244
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
- A. Bytes scanned
- B. Percentage scanned from cache
- C. Number of partitions scanned
- D. Bytes sent over the network
- E. External bytes scanned
Answer: A,C
NEW QUESTION 245
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. False
- B. True
Answer: B
NEW QUESTION 246
Which of the following objects can be cloned? (Choose four.)
- A. Shares
- B. Named File Formats
- C. Tables
- D. Users
- E. Schemas
- F. Databases
Answer: B,C,E,F
Explanation:
Explanation
Which Objects Can Be Cloned?
Data Containment Objects. Databases. Schemas. Tables. Streams.
Data Configuration and Transformation Objects. Stages. File Formats. Sequences. Tasks
NEW QUESTION 247
What tasks can be completed using the copy command? (Select TWO)
- A. Columns can be joined with an existing table
- B. Columns can be omitted
- C. Columns can be aggregated
- D. Columns can be reordered
- E. Data can be loaded without the need to spin up a virtual warehouse
Answer: B,D
NEW QUESTION 248
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)
- A. Amazon Web Services
- B. IBM Cloud
- C. Docker
- D. Microsoft Azure Cloud
- E. Oracle Cloud
- F. Google Cloud Platform
Answer: C,D,F
NEW QUESTION 249
......
Updated Verified SnowPro-Core dumps Q&As - Pass Guarantee or Full Refund: https://www.free4dump.com/SnowPro-Core-braindumps-torrent.html
Updated Certification Exam SnowPro-Core Dumps - Practice Test Questions: https://drive.google.com/open?id=1XzQZL8-zrri4dteoRE8AeEtr9iC4LiaA