100% Updated Snowflake SnowPro-Core Enterprise PDF Dumps
Use Valid Exam SnowPro-Core by Exam-Killer Books For Free Website
NEW QUESTION 83
True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.
- A. False
- B. True
Answer: A
NEW QUESTION 84
What is the most granular object that the Time Travel retention period can be defined on?
Select one.
- A. Account
- B. Database
- C. Table
- D. Schema
Answer: A
NEW QUESTION 85
In which layer of its architecture does Snowflake store its metadata statistics?
- A. Compute Layer
- B. Cloud Services Layer
- C. Storage Layer
- D. Database Layer
Answer: B
Explanation:
Explanation/Reference: https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/
NEW QUESTION 86
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.
- A. False
- B. True
Answer: B
NEW QUESTION 87
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
- A. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
- B. validation_mode=return_all_errors is a parameter of the copy command
- C. The validation_mode option is used when creating an Internal Stage
- D. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
Answer: A,B
NEW QUESTION 88
True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.
- A. False
- B. True
Answer: A
NEW QUESTION 89
True or False: All Snowflake table types include fail-safe storage.
- A. False
- B. True
Answer: A
NEW QUESTION 90
Which of the following is true of Snowpipe via REST API? (Choose two.)
- A. Snowflake automatically manages the compute required to execute the Pipe's COPY INTO commands
- B. Snowpipe keeps track of which files it has loaded
- C. All COPY INTO options are available during pipe creation
- D. You can only use it on Internal Stages
Answer: B,C
NEW QUESTION 91
Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answers
- A. ODBC
- B. R
- C. SnowSQL
- D. HIVE
Answer: A,C
NEW QUESTION 92
Which type of table corresponds to a single Snowflake session?
- A. Provisional
- B. Temporary
- C. Transient
- D. Permanent
Answer: B
NEW QUESTION 93
Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)
- A. Storage expands without the requirement to add more compute
- B. Compute can be scaled up or down without the requirement to add more storage
- C. Multiple compute clusters can access stored data without contention
- D. Growth of storage and compute are tightly coupled together
Answer: D
Explanation:
Explanation/Reference: https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehouse- doesnt-separate-storage-and-compute-65d2dffd450f
NEW QUESTION 94
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.
- A. False
- B. True
Answer: A
NEW QUESTION 95
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
- A. Is only available to customers with Business Critical Edition
- B. Is activated using an "ALTER DATABASE" command
- C. Restricts or enables access to specific IP addresses
- D. Is available to all Snowflake Editions
Answer: C,D
NEW QUESTION 96
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
- A. 3 Hours
- B. 24 hours
- C. 1 Hour
- D. 12 hours
Answer: B
Explanation:
Explanation/Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse
NEW QUESTION 97
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.
- A. False
- B. True
Answer: A
NEW QUESTION 98
Which of the following statements is true of Snowflake?
- A. It was built as an on-premises solution and then ported to the cloud
- B. It's based on an Oracle Architecture
- C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
- D. It was built specifically for the cloud
- E. It was built for Hadoop architecture
Answer: D
NEW QUESTION 99
True or False: Snowflake charges a premium for storing semi-structured data.
- A. False
- B. True
Answer: A
NEW QUESTION 100
......
Understanding functional and technical aspects of SnowPro Core Certification
The following will be discussed in SNOWFLAKE SNOWPRO CORE dumps:
- Unloading data from Snowflake to External Cloud Storage (S3,GCS,AZURE BLOB)
- Unloading data from Snowflake to Internal Snowflake Storage
- Account Management
- Caching
- Drive Data Unloading Considerations
- Load Testing
- Clustering
- Data Unloading
- Different Formats, Variant Table Type
- Query Profile
- Performance Management
- Semi Structured Data
- Unloading data from Snowflake to Local / Network
- Native Syntax, Flattening Data
- Query Performance & Analysis
- SQL optimization
Snowflake SnowPro-Core Official Cert Guide PDF: https://www.exam-killer.com/SnowPro-Core-valid-questions.html
Free SnowPro Core SnowPro-Core Official Cert Guide PDF Download: https://drive.google.com/open?id=1or8XZh7QmZTDrqajtKCFENW448jNqk1j
