SnowPro-Core PDF Download Feb-2024 Snowflake Test To Gain Brilliante Result!
Provide Updated Snowflake SnowPro-Core Dumps as Practice Test and PDF
To become SnowPro-Core certified, candidates must have a good understanding of SQL and data warehousing concepts, as well as hands-on experience with Snowflake's data platform. SnowPro-Core exam consists of 70 multiple-choice questions and takes two hours to complete. The passing score for the exam is 300 out of 500. Upon passing the exam, candidates receive a digital badge and certificate that can be shared on social media and professional networking sites. SnowPro-Core certification not only validates a candidate's skills and knowledge but also demonstrates their commitment to staying up-to-date with the latest technologies and best practices in data management and analytics.
NEW QUESTION # 63
What tasks can be completed using the copy command? (Select TWO)
- A. Columns can be aggregated
- B. Columns can be omitted
- C. Columns can be reordered
- D. Columns can be joined with an existing table
- E. Data can be loaded without the need to spin up a virtual warehouse
Answer: B,C
NEW QUESTION # 64
True or False: Snowpipe via REST API can only reference External Stages as source.
- A. True
- B. False
Answer: B
Explanation:
Explanation/Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default
NEW QUESTION # 65
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
- A. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.
- B. All Snowflake accounts must be hosted in the same cloud vendor and region
- C. Each Snowflake account must be hosted in a different cloud vendor and region
- D. Each Snowflake account can be hosted in a different cloud vendor and region.
Answer: C
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/intro-regions.html
NEW QUESTION # 66
Which object allows you to limit the number of credits consumed within a Snowflake account?
Select one.
- A. Resource Monitor
- B. Warehouse Limit Parameter
- C. Credit Consumption Tracker
- D. Account usage Tracking
Answer: A
Explanation:
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 # 67
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. True
- B. False
Answer: B
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 # 68
Which command is used to unload files from an internal or external stage to a local file system?
- A. TRANSFER
- B. GET
- C. COPY INTO
- D. PUT
Answer: C
NEW QUESTION # 69
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
- A. Number of users
- B. Amount of data processed
- C. # of clusters for the Warehouse
- D. Warehouse size
Answer: C,D
Explanation:
https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage "Snowflake credits are charged based on the number of virtual warehouses you use, how long they run, and their size."
NEW QUESTION # 70
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
- A. Incremental backups
- B. Fail-safe
- C. Internal stages
- D. Time Travel
- E. Zero-copy clones
Answer: B,D
Explanation:
Explanation
Time travel and fail safe are the two continuous data protection features support the recovery of data automatically.
Snowflake provides powerful CDP features for ensuring the maintenance and availability of your historical data (i.e. data that has been changed or deleted):
* Querying, cloning, and restoring historical data in tables, schemas, and databases for up to 90 days through Snowflake Time Travel.
* Disaster recovery of historical data (by Snowflake) through Snowflake Fail-safe.
https://docs.snowflake.com/en/user-guide/data-availability.html
NEW QUESTION # 71
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
- A. DML statements that are being issued against the table are blocked
- B. The table has a small number of micro-partitions
- C. The table contains a column that has very low cardinality
- D. Queries on the table are running slower than expected
- E. The clustering depth for the table is large
Answer: C,E
NEW QUESTION # 72
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
- A. XML
- B. Parquet
- C. ORC
- D. JSON
- E. Avro
Answer: B,D
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 # 73
Which Snowflake architectural layer is responsible for a query execution plan?
- A. Cloud provider
- B. Cloud services
- C. Compute
- D. Data storage
Answer: A
NEW QUESTION # 74
What is the recommended way to change the existing file format type in my format from CSV to JSON?
- A. ALTER FILE FORMAT my format SWAP TYPE WITH JSON;
- B. REPLACE FILE FORMAT my format TYPE-JSON;
- C. CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;
- D. ALTER FILE FORMAT my_format SET TYPE=JSON;
Answer: C
NEW QUESTION # 75
True or False: Pipes can be suspended and resumed.
- A. True
- B. False
Answer: B
NEW QUESTION # 76
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
- A. True
- B. False
Answer: B
NEW QUESTION # 77
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
- A. To accommodate more users
- B. To accommodate fluctuations in workload
- C. To accommodate a more complex workload
- D. To accommodate more queries
Answer: D
NEW QUESTION # 78
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?
- A. Default Time Travel Retention is set to 90 days.
Maximum Time Travel Retention is 7 days.
Fail Safe retention time is 356 days. - B. Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days. - C. Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days. - D. Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 365 days.
Fail Safe retention time is 7 days. - E. Default Time Travel Retention is set to 7 days.
Maximum Time Travel Retention is 1 day.
Fail Safe retention time is 90 days. - F. Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 30 days.
Fail Safe retention time is 1 day.
Answer: C
NEW QUESTION # 79
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 show warehouses command
- C. The load HISTORY view
- D. The Query history view
- E. The WAREHOUSE_METERING__HISTORY View
Answer: A,E
NEW QUESTION # 80
True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.
- A. True
- B. False
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/credits.html
NEW QUESTION # 81
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
- A. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
- B. MAX_CONCURRENCY__LEVEL
- C. QUERY_TIMEOUT_IN_SECONDS
- D. STATEMENT_TIMEOUT__IN__SECONDS
Answer: A
Explanation:
The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue
https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text=The%20parameter%20STATEMENT_QUEUED_TIMEOUT_IN_SECONDS%20sets%20the,indefinitely%20in%20the%20waiting%20queue.
NEW QUESTION # 82
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
- A. Compute layer
- B. Cloud infrastructure layer
- C. Cloud services layer
- D. Storage layer
Answer: A
Explanation:
For query execution, Snowflake uses the Virtual Warehouse. The query processing layer is separated from the disk storage layer in the Snowflake data architecture. You can use the data from the storage layer to run queries in this layer
https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556#:~:text=Query%20Processing%20Layer%2FCompute%20Layer,run%20queries%20in%20this%20layer.
NEW QUESTION # 83
What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?
- A. The REFRESH command is executed.
- B. The destination table is truncated.
- C. The stage will be purged.
- D. The Pipe load history is reset to empty.
Answer: A
NEW QUESTION # 84
......
The SnowPro-Core Certification Exam consists of multiple-choice questions, covering various aspects of Snowflake, including architecture, security, data loading, querying, and optimization. SnowPro-Core exam is conducted online, and candidates have two hours to complete it. SnowPro-Core exam is available in English and Japanese languages.
SnowPro-Core Dumps are Available for Instant Access: https://www.testsdumps.com/SnowPro-Core_real-exam-dumps.html
Valid SnowPro-Core Dumps for Helping Passing SnowPro-Core Exam!: https://drive.google.com/open?id=1y5e_4mSV4gEA1C-JGSXzK7xHgp3H4eZi
