Prepare For Realistic SnowPro-Core Dumps PDF - 100% Passing Guarantee
Check the Available SnowPro-Core Exam Dumps with 415 Q's
How to Prepare For SnowPro Core Certification
Preparation Guide for SnowPro Core Certification
Introduction for SnowPro Core Certification
SnowPro Core Certified individuals have demonstrated the knowledge necessary to apply specific core expertise in the marketplace with customers implementing and migrating to Snowflake. A SnowPro Core Certified 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.
Our SNOWFLAKE SNOWPRO CORE practice exams and SNOWFLAKE SNOWPRO CORE practice exams are there to help you in memorizing and understanding all the topics. Use them to prepare for all of the exam requirements.
Snowflake is a cloud data platform built from the ground up for the cloud. Snowflake is built on a patented, multi-cluster, shared data architecture created for the cloud to revolutionize data warehousing, data lakes, data analytics and a host of other use cases.
Snowflake is a single platform comprised of storage, compute, and services layers that are logically integrated but scale infinitely and independent from one another.
Snowflake is a SaaS solution and is maintained by Snowflake and not the customer. Snowflake manages the services, compute, and storage layers. Data is only accessible via SQL in Snowflake. Snowflake can be deployed within AWS, Azure or GCP although not in customer controlled accounts.
NEW QUESTION 230
Which object allows you to limit the number of credits consumed within a Snowflake account?
Select one.
- A. Credit Consumption Tracker
- B. Account usage Tracking
- C. Warehouse Limit Parameter
- D. Resource Monitor
Answer: D
Explanation:
The time travel data retention can be overwritten at the table level "When creating a table, schema, or database, the account default can be overridden using the DATA_RETENTION_TIME_IN_DAYS parameter in the command."
NEW QUESTION 231
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
- A. To accommodate more queries
- B. To accommodate a more complex workload
- C. To accommodate more users
- D. To accommodate fluctuations in workload
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html
NEW QUESTION 232
Using variables in Snowflake is denoted by using which SQL character?
- A. &
- B. @
- C. $
- D. #
Answer: C
NEW QUESTION 233
What is a best practice after creating a custom role?
- A. Create the custom role using the SYSADMIN role.
- B. Assign the custom role to the PUBLIC role
- C. Assign the custom role to the SYSADMIN role
- D. Add__CUSTOM to all custom role names
Answer: C
Explanation:
When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN. This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.
NEW QUESTION 234
Where can a user find and review the failed logins of a specific user for the past 30 days?
- A. The SESSIONS view in ACCOUNT_USAGE
- B. The ACCESS_HISTORY view in ACCOUNT_USAGE
- C. The LOGIN_HISTORY view in ACCOUNT_USAGE
- D. The USERS view in ACCOUNT_USAGE
Answer: C
NEW QUESTION 235
True or False: Fail-safe can be disabled within a Snowflake account.
- A. True
- B. False
Answer: B
NEW QUESTION 236
What is the purpose of multi-cluster virtual warehouses?
- A. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
- B. To eliminate or reduce Queuing of concurrent queries
- C. To create separate data warehouses to increase query optimization
- D. To allow the warehouse to resize automatically
Answer: B
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi%2Dcluster%20warehous
NEW QUESTION 237
What actions will prevent leveraging of the ResultSet cache? (Choose two.)
- A. Changing a column that is not in the cached query
- B. Stopping the virtual warehouse that the query is running against
- C. Removing a column from the query SELECT list
- D. Clustering of the data used by the query
- E. Executing the RESULTS_SCAN() table function
Answer: C,E
NEW QUESTION 238
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
- A. Custom
- B. Economy
- C. Optimized
- D. Standard
Answer: B,D
Explanation:
Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance
NEW QUESTION 239
Which of the following items does the Cloud services Layer manage?
Choose 4 answers
- A. Metadata
- B. Query compilation and optimization
- C. external blob storage
- D. user authentication
- E. Data security
Answer: A,B,D,E
NEW QUESTION 240
Which command is used to unload data from a Snowflake table into a file in a stage?
- A. GET
- B. COPY INTO
- C. EXTRACT INTO
- D. WRITE
Answer: B
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=Your%20User%20Stage-,Use%2
NEW QUESTION 241
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
- A. True
- B. False
Answer: B
Explanation:
Explanation
By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data to a single output file (at the potential cost of decreased performance), specify the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the path.
NEW QUESTION 242
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.
- A. True
- B. False
Answer: A
NEW QUESTION 243
What is the most granular object that the Time Travel retention period can be defined on?
Select one.
- A. Schema
- B. Database
- C. Account
- D. Table
Answer: D
NEW QUESTION 244
True or False: Users are able to see the result sets of queries executed by other users that share their same role.
- A. True
- B. False
Answer: B
NEW QUESTION 245
What can be used to view warehouse usage over time? (Select Two).
- A. The billing and usage tab in the Snowflake web Ul
- B. The Query history view
- C. The load HISTORY view
- D. The show warehouses command
- E. The WAREHOUSE_METERING__HISTORY View
Answer: A,E
NEW QUESTION 246
What is a key feature of Snowflake architecture?
- A. Zero-copy cloning creates a mirror copy of a database that updates with the original
- B. Software updates are automatically applied on a quarterly basis
- C. Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
- D. Multi-cluster warehouses allow users to run a query that spans across multiple clusters
- E. Snowflake eliminates resource contention with its virtual warehouse implementation
Answer: D
NEW QUESTION 247
What is cached during a query on a virtual warehouse?
- A. All rows accessed during the query
- B. Any columns accessed during the query
- C. The columns in the result set of the query
- D. All columns in a micro-partition
Answer: B
NEW QUESTION 248
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 Internal Stage
- B. Bulk copy from an External Stage
- C. The Snowflake Web Interface (UT) data loading wizard
- D. Continuous load using Snowpipe REST API
Answer: B,C,D
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-load-overview.html
NEW QUESTION 249
Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)
- A. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
- B. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
- C. The default virtual warehouse size can be changed at any time.
- D. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
- E. A user cannot specify a default warehouse when using the ODBC driver.
Answer: B
NEW QUESTION 250
True or False: Pipes can be suspended and resumed.
- A. True
- B. False
Answer: B
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
NEW QUESTION 251
When can a Virtual Warehouse start running queries?
- A. 12am-5am
- B. When its provisioning is complete
- C. After replication
- D. Only during administrator defined time slots
Answer: B
Explanation:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION 252
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
- A. XML
- B. Parquet
- C. ORC
- D. Avro
- E. JSON
Answer: B,E
Explanation:
Semi-structured
JSON, Parquet
https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20file&text=Delimited%20(CSV%2C%20TSV%2C%20etc.)
NEW QUESTION 253
Which minimum Snowflake edition allows for a dedicated metadata store?
- A. Standard
- B. Business Critical
- C. Enterprise
- D. Virtual Private Snowflake
Answer: D
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
NEW QUESTION 254
......
Download SnowPro-Core Exam Dumps Questions to get 100% Success: https://www.actualcollection.com/SnowPro-Core-exam-questions.html
100% Accurate Answers! SnowPro-Core Actual Real Exam Questions: https://drive.google.com/open?id=1jCoYFFNWnzRJpVTUulSSEC9DW_PIY2t2