2024 100% Free SnowPro-Core Daily Practice Exam With 630 Questions

SnowPro-Core exam torrent Snowflake study guide

The SnowPro-Core exam is designed to evaluate professionals' skills and knowledge in designing, deploying, and managing a cloud analytics platform using Snowflake. SnowPro-Core exam is appropriate for data engineers, analysts, architects, and administrators, among others, looking to improve their skills in data warehousing and cloud analytics with Snowflake. SnowPro-Core exam tests skills in the use of the Snowflake architecture, data migration, database administration, SQL coding, data modeling, and data security.

 

NEW QUESTION # 132
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?

• A. GRANT ROLE MYROLE TO USER USER1;
  GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE
  MYROLE;
• B. GRANT ROLE MYROLE TO USER USER1;
  GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
• C. GRANT ROLE MYROLE TO USER USER1;
  GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
• D. GRANT ROLE MYROLE TO USER USER1;
  GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K"-'SCHEMA TO USER! ;

Answer: A

NEW QUESTION # 133
When should a multi-cluster warehouse be used in auto-scaling mode?

• A. If the runtime of the executed query is very slow
• B. When a large number of concurrent queries are run on the same warehouse
• C. When it is unknown how much compute power is needed
• D. If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

Answer: B

Explanation:
A multi-cluster warehouse should be used in auto-scaling mode when there is a need to handle a large number of concurrent queries. Auto-scaling allows Snowflake to automatically add or remove compute clusters to balance the load, ensuring that performance remains consistent during varying levels of demand

NEW QUESTION # 134
By definition, a secure view is exposed only to users with what privilege?

• A. IMPORT SHARE
• B. REFERENCES
• C. OWNERSHIP
• D. USAGE

Answer: C

Explanation:
A secure view in Snowflake is exposed only to users with the OWNERSHIP privilege. This privilege ensures that only authorized users who own the view, or roles that include ownership, can access the secure view

NEW QUESTION # 135
What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

• A. The Pipe load history is reset to empty.
• B. The destination table is truncated.
• C. The REFRESH command is executed.
• D. The stage will be purged.

Answer: A

Explanation:
When a pipe is recreated using the CREATE OR REPLACE PIPE command, the load history of the pipe is reset. This means that Snowpipe will consider all files in the stage as new and will attempt to load them, even if they were loaded previously by the old pipe2.

NEW QUESTION # 136
What is used to diagnose and troubleshoot network connections to Snowflake?

• A. Snowpark
• B. SnowCD
• C. SnowSQL
• D. Snowsight

Answer: B

Explanation:
SnowCD (Snowflake Connectivity Diagnostic Tool) is used to diagnose and troubleshoot network connections to Snowflake. It runs a series of connection checks to evaluate the network connection to Snowflake

NEW QUESTION # 137
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

• A. MONITOR
• B. OPERATE
• C. MODIFY
• D. USAGE

Answer: B

Explanation:
Reference:
https://community.snowflake.com/s/question/0D50Z00008yHYdqSAG/auto-resume-operate-warehouse-privileg

NEW QUESTION # 138
What feature can be used to reorganize a very large table on one or more columns?

• A. Key partitions
• B. Micro-partitions
• C. Clustering keys
• D. Clustered partitions

Answer: C

Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

NEW QUESTION # 139
True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

• A. False
• B. True

Answer: A

NEW QUESTION # 140
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

• A. An error will occur, as stored objects cannot be cloned.
• B. An error will occur, as views with qualified references cannot be cloned.
• C. The cloned views and the stored procedures will reference the cloned tables in the cloned database.
• D. The stored procedures and views will refer to tables in the source database.

Answer: C

Explanation:
When cloning a database containing stored procedures and regular views with fully qualified table references, the cloned views and stored procedures will reference the cloned tables in the cloned database (A). This ensures that the cloned database is a self-contained copy of the original, with all references pointing to objects within the same cloned database. References: SnowPro Core Certification cloning database stored procedures views

NEW QUESTION # 141
True or False: A Virtual Warehouse can be resized while suspended.

• A. True
• B. False

Answer: A

Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse

NEW QUESTION # 142
The PUT command: (Choose two.)

• A. Automatically encrypts files
• B. Automatically creates a File Format object
• C. Automatically compresses files using Gzip
• D. Automatically uses the last Stage created

Answer: A,C

NEW QUESTION # 143
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

• A. 0
• B. 1
• C. 2
• D. 3

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

NEW QUESTION # 144
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

• A. False
• B. True

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

NEW QUESTION # 145
How can a Snowflake user traverse semi-structured data?

• A. Insert a double colon (: :) between the VARIANT column name and any first-level element.
• B. Insert a colon (:) between the VARIANT column name and any second-level element.
• C. Insert a double colon (: :) between the VARIANT column name and any second-level element.
• D. Insert a colon (:) between the VARIANT column name and any first-level element.

Answer: D

Explanation:
To traverse semi-structured data in Snowflake, a user can insert a colon (:) between the VARIANT column name and any first-level element. This path syntax is used to retrieve elements in a VARIANT column4.

NEW QUESTION # 146
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

• A. Pipes
• B. Streams
• C. Procedures
• D. Tasks

Answer: B

Explanation:
In Snowflake, Streams are the objects that track Data Manipulation Language (DML) changes made to tables, such as inserts, updates, and deletes. Streams record these changes along with metadata about each change, enabling actions to be taken using the changed data. This process is known as change data capture (CDC)2.

NEW QUESTION # 147
Which of the following objects can be shared through secure data sharing?

• A. Task
• B. External table
• C. Masking policy
• D. Stored procedure

Answer: B

Explanation:
Secure data sharing in Snowflake allows users to share various objects between Snowflake accounts without physically copying the data, thus not consuming additional storage. Among the options provided, external tables can be shared through secure data sharing. External tables are used to query data directly from files in a stage without loading the data into Snowflake tables, making them suitable for sharing across different Snowflake accounts.
References:
* Snowflake Documentation on Secure Data Sharing
* SnowPro Core Certification Companion: Hands-on Preparation and Practice

NEW QUESTION # 148
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

• A. Microsoft Azure Cloud
• B. IBM Cloud
• C. Google Cloud Platform
• D. Oracle Cloud
• E. Amazon Web Services
• F. Docker

Answer: A,C,E

Explanation:
Snowflake supports the use of external stages with Amazon Web Services (AWS), Microsoft Azure Cloud, and Google Cloud Platform (GCP). These platforms allow users to stage data externally and integrate with Snowflake for data loading operations

NEW QUESTION # 149
Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?

• A. DELETE
• B. REMOVE
• C. PURGE
• D. MODIFY

Answer: A

Explanation:
Reference:
https://www.simplilearn.com/tutorials/sql-tutorial/delete-in-sql#:~:text=The%20Delete%20command%20in%20

NEW QUESTION # 150
What is the MAXIMUM Time Travel retention period for a transient table?

• A. 7 days
• B. O days
• C. 90 days
• D. 1 day

Answer: D

NEW QUESTION # 151
What is true about sharing data in Snowflake? (Choose two.)

• A. The Provider is charged for compute resources used by the Data Consumer to query the shared data.
• B. A Snowflake account can both provide and consume shared data.
• C. The Data Consumer pays for data storage as well as for data computing.
• D. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
• E. The Data Consumer pays only for compute resources to query the shared data.

Answer: B,D

NEW QUESTION # 152
......

Use Valid New SnowPro-Core Test Notes & SnowPro-Core Valid Exam Guide: https://www.vce4dumps.com/SnowPro-Core-valid-torrent.html

SnowPro-Core Actual Questions Answers PDF 100% Cover Real Exam Questions: https://drive.google.com/open?id=14osxF9A5_8ScnfxyJCn66CpAGhtCfcLM