[Full-Version] 2023 New SnowPro-Core Actual Exam Dumps, Snowflake Practice Test
Study HIGH Quality SnowPro-Core Free Study Guides and Exams Tutorials
NEW QUESTION # 198
True or False: It is possible to load data into Snowflake without creating a named File Format object.
- A. False
- B. True
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html
NEW QUESTION # 199
Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?
Select one.
- A. 12 hours
- B. 3 Hours
- C. 1 Hour
- D. 24 hours
Answer: D
Explanation:
Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse
NEW QUESTION # 200
Snowflake is designed for which type of workloads? (Choose two.)
- A. OLAP (Analytics) workloads
- B. OLTP (Transactional) workloads
- C. Concurrent workloads
- D. On-premise workloads
Answer: A,C
NEW QUESTION # 201
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)
- A. A Warehouse can be configured to suspend after a period of inactivity
- B. A Warehouse can be configured to auto-resume when new queries are submitted
- C. A Warehouse can be resized while running
- D. Customers can change the size of the Warehouse after creation
Answer: A,B,C,D
NEW QUESTION # 202
A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?
- A. Query against the metadata excite
- B. Query against the result set cache
- C. Query against a virtual warehouse cache
- D. Query against the most-recently created micro-partition
Answer: A
NEW QUESTION # 203
Which of the following statements describes a schema in Snowflake?
- A. A logical grouping of objects that belongs to a single database
- B. A logical grouping of objects that belongs to multiple databases
- C. A uniquely identified Snowflake account within a business entity
- D. A named Snowflake object that includes all the information required to share a database
Answer: A
NEW QUESTION # 204
Which command can be used to load data files into a Snowflake stage?
- A. JOIN
- B. COPY INTO
- C. PUT
- D. GET
Answer: C
NEW QUESTION # 205
True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.
- A. False
- B. True
Answer: B
Explanation:
Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.
NEW QUESTION # 206
Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)?
Choose 2 answers
- A. SQL
- B. Python
- C. Java
- D. JavaScript
Answer: A,D
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/user-defined-functions.html
NEW QUESTION # 207
What happens when a Data Provider revokes privileges to a Share on an object in their source database?
- A. The object immediately becomes unavailable for all Data Consumers
- B. The Data Consumers stop seeing data updates and become responsible for storage charges for the object
- C. Any additional data arriving after this point in time will not be visible to Data Consumers
- D. A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts
Answer: A
NEW QUESTION # 208
Which of the following DML commands isn't supported by Snowflake?
- A. TRUNCATE TABLE
- B. UPDATE
- C. MERGE
- D. UPSERT
Answer: D
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/sql-reference/sql-dml.html
NEW QUESTION # 209
What happens when a database is cloned?
- A. It replicates all granted privileges on the corresponding child schema objects.
- B. It replicates all granted privileges on the corresponding child objects.
- C. It does not retain any privileges granted on the source object.
- D. It replicates all granted privileges on the corresponding source objects.
Answer: B
NEW QUESTION # 210
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
- A. Amount of data processed
- B. Warehouse size
- C. # of clusters for the Warehouse
- D. Number of users
Answer: B,C
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 # 211
Network policies can be set at which Snowflake levels? (Choose two.)
- A. User
- B. Role
- C. Schema
- D. Account
- E. Database
- F. Tables
Answer: A,D
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/network-policies.html#creating-network-policies
NEW QUESTION # 212
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.
- A. True
- B. False
Answer: B
NEW QUESTION # 213
Which of the following terms best describes Snowflake's database architecture?
- A. Shared disk
- B. Multi-cluster, shared data
- C. Cloud-native shared memory
- D. Columnar shared nothing
Answer: A
NEW QUESTION # 214
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)
- A. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
- B. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.
- C. Scaling out adds clusters of varying sizes to a virtual warehouse.
- D. Scaling up resizes a virtual warehouse so it can handle more complex workloads.
- E. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
- F. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
Answer: A,D
NEW QUESTION # 215
True or False: Pipes can be suspended and resumed.
- A. False
- B. True
Answer: B
Explanation:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe:
NEW QUESTION # 216
Which of the following best describes where Snowflake's metadata is stored?
- A. within the drivers
- B. Within the data files
- C. Inside the Virtual Warehouses
- D. In the Cloud Services Layer
Answer: D
NEW QUESTION # 217
......
Get 100% Real Free SnowPro Core SnowPro-Core Sample Questions: https://freedownload.prep4sures.top/SnowPro-Core-real-sheets.html