SnowPro-Core Free Study Guide! with New Update 339 Exam Questions
Get up-to-date Real Exam Questions for SnowPro-Core UPDATED [2023]
Snowflake is a cloud-based data platform that offers seamless data integration, data warehousing, data analytics, and data sharing capabilities to organizations across the globe. It is a powerful tool that is built to provide customers with excellent performance, scalability, and flexibility. One of the cornerstones of Snowflake's offerings is the Snowflake SnowPro-Core Certification Exam.
NEW QUESTION # 102
Which of the following statements are true of Snowflake releases: (Choose two.)
- A. During a release, new customer requests/queries/connections transparently move over to the newer version
- B. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded
- C. They roll up and release approximately monthly, but customers can request early release application
- D. They happen approximately weekly
Answer: A,B
NEW QUESTION # 103
How many days is load history for Snowpipe retained?
- A. 14 days
- B. 1 day
- C. 7 days
- D. 64 days
Answer: A
NEW QUESTION # 104
True or False: You can query the files in an External Stage directly without having to load the data into a table.
- A. True
- B. False
Answer: A
Explanation:
Reference:
External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.
NEW QUESTION # 105
Which of the following DML commands isn't supported by Snowflake?
- A. MERGE
- B. UPSERT
- C. UPDATE
- D. TRUNCATE TABLE
Answer: B
NEW QUESTION # 106
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?
- A. Use a larger-sized warehouse.
- B. Split the file into multiple files in the recommended size range (100 MB - 250 MB).
- C. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.
- D. Compress the file and load the compressed file.
Answer: D
NEW QUESTION # 107
Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?
- A. User-Defined Table Functions (UDTF)
- B. External Tokenization
- C. External Tables
- D. Materialized Views
Answer: B
NEW QUESTION # 108
What is the following SQL command used for?
Select * from table(validate(t1, job_id => '_last'));
- A. To validate a file for errors before it gets executed using a COPY command
- B. To validate task SQL statements against table t1 in the last 14 days
- C. To return errors from the last executed COPY command into table t1 in the current session
- D. To validate external table files in table t1 across all sessions
Answer: C
NEW QUESTION # 109
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?
- A. Create a zero-copy clone of the worksheet and grant permissions to teammates
- B. Share the worksheet with teammates within Snowsight
- C. Create a private Data Exchange so that any teammate can use the worksheet
- D. Create a database and grant all permissions to teammates
Answer: B
NEW QUESTION # 110
What feature can be used to reorganize a very large table on one or more columns?
- A. Clustered partitions
- B. Clustering keys
- C. Key partitions
- D. Micro-partitions
Answer: B
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
NEW QUESTION # 111
Which of the following statements is true of zero-copy cloning?
- A. Zero-copy coning is licensed as an additional Snowflake feature
- B. Zero-copy clones objects inherit
- C. All zero-copy clone objects inherit the privileges of their original objects
- D. At the instance/instance a clone is created, all micro-partitions in the original table and the clone are fully shared.
Answer: D
NEW QUESTION # 112
True or False: Data Providers can share data with only the Data Consumer.
- A. True
- B. False
Answer: B
NEW QUESTION # 113
Which command is used to unload files from an internal or external stage to a local file system?
- A. TRANSFER
- B. GET
- C. PUT
- D. COPY INTO
Answer: D
NEW QUESTION # 114
A Virtual Warehouse's auto-suspend and auto-resume settings apply to:
- A. The primary duster in the virtual warehouse
- B. The database the Virtual Warehouse resides in
- C. The entire Virtual Warehouse
- D. The queries currently being run by the Virtual Warehouse
Answer: C
NEW QUESTION # 115
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 # 116
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?
- A. Premium
- B. Enterprise
- C. Business Critical
- D. Standard
Answer: C
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/privatelink-azure.html
NEW QUESTION # 117
What is the maximum compressed row size in Snowflake?
- A. 8KB
- B. 16MB
- C. 50MB
- D. 4000GB
Answer: B
NEW QUESTION # 118
What impacts the credit consumption of maintaining a materialized view? (Choose two.)
- A. How often the materialized view is queried
- B. How often the underlying base table is queried
- C. How often the base table changes
- D. Whether or not it is also a secure view
- E. Whether the materialized view has a cluster key defined
Answer: A,E
NEW QUESTION # 119
Which services does the Snowflake Cloud Services layer manage? (Select TWO).
- A. Compute resources
- B. Authentication
- C. Query execution
- D. Metadata
- E. Data storage
Answer: B,D
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider.
Services managed in this layer include:
* Authentication
* Infrastructure management
* Metadata management
* Query parsing and optimization
* Access control
NEW QUESTION # 120
If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
- A. Table definition
- B. Session level
- C. Stage definition
- D. COPY INTO TABLE statement
Answer: D
NEW QUESTION # 121
......
Pass Snowflake SnowPro-Core Exam in First Attempt Guaranteed: https://measureup.preppdf.com/Snowflake/SnowPro-Core-prepaway-exam-dumps.html