SnowPro-Core Certification Exam Dumps Questions in here [Aug-2023]
Updated SnowPro-Core Exam Practice Test Questions
NEW QUESTION # 166
What is the minimum Snowflake edition required for row level security?
- A. Virtual Private Snowflake
- B. Enterprise
- C. Standard
- D. Business Critical
Answer: B
NEW QUESTION # 167
Which data type can be used to store geospatial data in Snowflake?
- A. Object
- B. Geometry
- C. Variant
- D. Geography
Answer: D
Explanation:
https://docs.snowflake.com/en/sql-reference/data-types-geospatial.html#:~:text=have%20SRID%3D4326.-,Geospatial%20Object%20Types,Point
NEW QUESTION # 168
Where is Snowflake metadata stored?
- A. Within the data files
- B. In the virtual warehouse layer
- C. In the cloud services layer
- D. In the remote storage layer
Answer: B
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/querying-metadata.html#:~:text=Snowflake%20automatically%20gen
NEW QUESTION # 169
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
- A. False
- B. True
Answer: A
NEW QUESTION # 170
True or False: Users are able to see the result sets of queries executed by other users that share their same role.
- A. False
- B. True
Answer: A
NEW QUESTION # 171
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
- A. Via the Snowflake Web Interface (Ul)
- B. Via the data_share=true parameter
- C. Via Virtual Warehouses
- D. Via SQL commands
Answer: A,D
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html
NEW QUESTION # 172
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
- A. Pipe
- B. Task
- C. External stage
- D. Stream
Answer: A
Explanation:
Explanation
Snowpipe enables loading data from files as soon as they're available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
NEW QUESTION # 173
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)
- A. Snowflake Web Interface (UI)
- B. Python
D18912E1457D5D1DDCBD40AB3BF70D5D - C. ODBC
- D. JDBC
- E. SnowSQL
Answer: A,B,C,D,E
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html
NEW QUESTION # 174
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?
- A. Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days. - B. Default Time Travel Retention is set to 7 days.
Maximum Time Travel Retention is 1 day.
Fail Safe retention time is 90 days. - C. Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 90 days.
Fail Safe retention time is 7 days. - D. Default Time Travel Retention is set to 0 days.
Maximum Time Travel Retention is 30 days.
Fail Safe retention time is 1 day. - E. Default Time Travel Retention is set to 90 days.
Maximum Time Travel Retention is 7 days.
Fail Safe retention time is 356 days. - F. Default Time Travel Retention is set to 1 day.
Maximum Time Travel Retention is 365 days.
Fail Safe retention time is 7 days.
Answer: A
NEW QUESTION # 175
What is cached during a query on a virtual warehouse?
- A. Any columns accessed during the query
- B. All rows accessed during the query
- C. All columns in a micro-partition
- D. The columns in the result set of the query
Answer: A
NEW QUESTION # 176
True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.
- A. false
- B. True
Answer: A
NEW QUESTION # 177
When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers
- A. When the compute must be available with no delay or lag time
- B. When managing a steady workload
- C. When users will be using compute at different times throughout a 24/7 period
- D. When you don't want to have to manually turn on the Warehouse each time a user needs it
Answer: A,B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html
NEW QUESTION # 178
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. MODIFY
- B. DELETE
- C. PURGE
- D. REMOVE
Answer: B
Explanation:
Reference:
https://www.simplilearn.com/tutorials/sql-tutorial/delete-in-sql#:~:text=The%20Delete%20command%20in%20
NEW QUESTION # 179
Which feature is only available in the Enterprise or higher editions of Snowflake?
- A. Object-level access control
- B. SOC 2 type II certification
- C. Multi-factor Authentication (MFA)
- D. Column-level security
Answer: D
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/intro-editions.html
NEW QUESTION # 180
Which item in the Data Warehouse migration process does not apply in Snowflake? (Select two)
- A. Migrate Users
- B. Build the Data pipeline
- C. Migrate Schemas
- D. Migrate Indexes
Answer: B,D
NEW QUESTION # 181
Which statement MOST accurately describes clustering in Snowflake?
- A. Clustering is the way data is grouped together and stored within Snowflake micro-partitions.
- B. Clustering can be disabled within a Snowflake account.
- C. The clustering key must be included in the COPY command when loading data into Snowflake.
- D. The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
Answer: A
NEW QUESTION # 182
Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:
- A. Scaling out
- B. Scaling Up
- C. Scaling max
- D. Scaling rhythmically
Answer: A
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#scaling-up-vs-scaling-out
"Scale out by adding warehouses to a multi-cluster warehouse"
NEW QUESTION # 183
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
- A. Use of multi-clustered warehouses
- B. The ability to scale up warehouses
- C. The ability to resize warehouses
- D. The use of warehouse auto scaling
- E. The use of warehouse indexing
Answer: A,D
NEW QUESTION # 184
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
- A. REPLACE_INVALID_CHARACTERS
- B. SKIP_BYTE_ORDER_MARK
- C. STRIP_NULL_VALUES
- D. VALIDATION_MODE
Answer: D
Explanation:
Explanation
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS
String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:
NEW QUESTION # 185
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
- A. QUERY_TIMEOUT_IN_SECONDS
- B. STATEMENT_TIMEOUT__IN__SECONDS
- C. MAX_CONCURRENCY__LEVEL
- D. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
Answer: D
Explanation:
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
NEW QUESTION # 186
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
- A. A Data Exchange allows groups of accounts to share data privately among the accounts.
- B. Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.
- C. If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.
- D. The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.
- E. A Data Exchange allows accounts to share data with third, non-Snowflake parties.
Answer: A
NEW QUESTION # 187
The Snowflake Search Optimization Services supports improved performance of which kind of query?
- A. Queries against large tables where frequent DML occurs
- B. Queries against tables larger than 1 TB
- C. Selective point lookup queries
- D. Queries against a subset of columns in a table
Answer: C
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/search-optimization-service.html#:~:text=The%20search%20optimiza
%20point,OBJECT%2C%20and%20ARRAY%20columns)
NEW QUESTION # 188
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
- A. False
- B. True
Answer: B
Explanation:
You can experiment the same with snowflake UI.
NEW QUESTION # 189
What Snowflake role must be granted for a user to create and manage accounts?
- A. ORGADMIN
- B. SYSADMIN
- C. SECURITYADMIN
- D. ACCOUNTADMIN
Answer: D
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
NEW QUESTION # 190
True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.
- A. False
- B. True
Answer: A
NEW QUESTION # 191
......
Pass SnowPro Core SnowPro-Core Exam With 339 Questions: https://braindumps.free4torrent.com/SnowPro-Core-valid-dumps-torrent.html