Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
SnowPro Core
Free trial
Verified
Question 176
What optional properties can a Snowflake user set when creating a virtual warehouse? (Choose two.)
- A: Auto-suspend
- B: Cache size
- C: Default role
- D: Resource monitor
- E: Storage size
Question 177
What is the purpose of the use of the VALIDATE command?
- A: To view any queries that encountered an error
- B: To verify that a SELECT query will run without error
- C: To prevent a PUT statement from running if an error occurs
- D: To see all errors from a previously run COPY INTO [table] statement
Question 178
Which function is used to unload a relational table into a JSON file?
- A: PARSE_JSON
- B: JSON_EXTRACT_PATH_TEXT
- C: OBJECT_CONSTRUCT
- D: TO_JSON
Question 179
True or False: Once created, a micro-partition will never be changed.
- A: True
- B: False
Question 180
Which command is used to unload data from a Snowflake table into a Snowflake stage?
- A: GET
- B: CREATE STAGE
- C: COPY INTO [location]
- D: PUT
Question 181
What should an account administrator do to help a user log into Snowflake, if the user cannot authenticate using Multi-Factor Authentication (MFA)?
- A: Set DISABLE_MFA to TRUE for the user.
- B: Set MINS_TO_BYPASS_MFA equal to 0 for the user.
- C: Set ALLOW_ID_TOKEN to FALSE for the user.
- D: Set ALLOW_CLIENT_MFA_CACHING to FALSE for the user.
Question 182
Which command can be executed from a reader account?
- A: INSERT
- B: CREATE SHARE
- C: SHOW PROCEDURES
- D: COPY INTO [location]
Question 183
Which command line parameter value can be pre-specified as an environment variable in SnowSQL?
- A: HOST
- B: VARIABLE
- C: OPTION
- D: MFA-PASSCODE
Question 184
Which command is used to determine the file name of each row of data from a staged file?
- A: SHOW FILE FORMATS
- B: SELECT METADATA$FILE_CONTENT_KEY
- C: SELECT METADATA$FILE_ROW_NUMBER
- D: SELECT METADATA$FILENAME
Question 185
Which Snowflake feature improves the performance of point lookup queries?
- A: Materialized views
- B: Automatic clustering
- C: Query acceleration service
- D: Search optimization service
Question 186
What is the impact of selecting one Snowflake edition over another? (Choose two.)
- A: The edition will impact the unit costs for storage.
- B: The edition will impact which regions can be accessed by the accounts.
- C: The edition will determine the unit costs for the compute credits.
- D: The edition will impact the total allowed storage space.
- E: The edition will set a limit on the number of compute credits that can be consumed.
Question 187
What services does Snowflake automatically provide for customers that they may have been responsible for with their on-premise system? (Choose all that apply.)
- A: Installing and configuring hardware
- B: Patching software
- C: Physical security
- D: Maintaining metadata and statistics
Question 188
Which command should be used to drop files from an internal or external stage?
- A: DELETE
- B: DROP
- C: REMOVE
- D: TRUNCATE
Question 189
Which parameters can be used together to ensure that a virtual warehouse never has a backlog of queued SQL statements? (Choose two.)
- A: STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
- B: STATEMENT_TIMEOUT_IN_SECONDS
- C: DATA_RETENTION_TIME_IN_DAYS
- D: MAX_CONCURRENCY_LEVEL
- E: MAX_DATA_EXTENSION_TIME_IN_DAYS
Question 190
What action should be taken if a large number of concurrent queries are queued in a virtual warehouse?
- A: Scale-up by resizing the warehouse.
- B: Scale-out with a multi-cluster warehouse.
- C: Disable auto-suspend on the warehouse.
- D: Enable auto-resume on the warehouse.
Question 191
Which feature is supported in column-level security in Snowflake?
- A: Object tagging
- B: Data classification
- C: External tokenization
- D: Tag-based masking policies
Question 192
A network policy applied at the user level takes precedence over a network policy applied to what Snowflake object?
- A: A role
- B: An account
- C: A database
- D: An organization
Question 193
Which Snowflake storage object can be used to store data beyond a single session and will not incur Fail-safe costs?
- A: Permanent table
- B: External table
- C: Temporary table
- D: Transient table
Question 194
Using which object-level parameters will help limit query processing and concurrency slowdowns? (Choose two.)
- A: MULTI_STATEMENT_COUNT
- B: ENABLE_QUERY_ACCELERATION
- C: STATEMENT_TIMEOUT_IN_SECONDS
- D: STATEMENT_QUEUED_TIMEOUT_IN_SECONDS
- E: QUERY_ACCELERATION_MAX_SCALE_FACTOR
Question 195
Which of the following statements would be used to export/unload data from Snowflake?
- A: COPY INTO @stage
- B: EXPORT TO @stage
- C: INSERT INTO @stage
- D: EXPORT_TO_STAGE(stage => @stage, select => 'select * from t1');
Question 196
The ORDERS table contains 12,000 rows.
Which query will return 10 rows that are randomly sampled from the table every time the query is run?
- A: select * from ORDERS fetch 10;
- B: select * from ORDERS limit 10;
- C: select * from ORDERS sample (10);
- D: select * from ORDERS tablesample (10 rows);
Question 197
Which function will convert semi-structured data to a relational data representation?
- A: PARSE_JSON
- B: FLATTEN
- C: OBJECT_CONSTRUCT
- D: OBJECT_AGG
Question 198
What triggers the automated maintenance of a table's clustering key after it has been defined?
- A: A scheduled task established by the ORGADMIN.
- B: A time-based schedule set by the user.
- C: A Snowflake determination based on the table size.
- D: A Snowflake determination that the table will benefit from maintenance.
Question 199
Which Snowflake object will consume credits during automatic background maintenance?
- A: View
- B: Table
- C: External table
- D: Materialized view
Question 200
Snowflake users can create a resource monitor at which levels? (Choose two.)
- A: User level
- B: Pipe level
- C: Account level
- D: Cloud services level
- E: Virtual warehouse level
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!