Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
SnowPro Core
Free trial
Verified
Question 51
A user with which privileges can create or manage other users in a Snowflake account? (Choose two.)
- A: GRANT
- B: SELECT
- C: MODIFY
- D: OWNERSHIP
- E: CREATE USER
Question 52
Which items are considered schema objects in Snowflake? (Choose two.)
- A: Pipe
- B: File format
- C: Resource monitor
- D: Storage integration
- E: Virtual warehouse
Question 53
What does SnowCD help Snowflake users to do?
- A: Copy data into files.
- B: Manage different databases and schemas.
- C: Troubleshoot network connections to Snowflake.
- D: Write SELECT queries to retrieve data from external tables.
Question 54
Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?
- A: MODIFY, MONITOR and OPERATE privileges
- B: OWNERSHIP and USAGE privileges
- C: APPLYBUDGET and AUDIT privileges
- D: MANAGE LISTING AUTOFULFILLMENT and RESOLVE ALL privileges
Question 55
A Snowflake account has activated federated authentication.
What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?
- A: The user will be unable to enter a password.
- B: The user will encounter an error, and will not be able to log in.
- C: The user will be able to log into Snowflake successfully.
- D: After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.
Question 56
Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?
- A: Automatic clustering
- B: Materialized views
- C: Query acceleration service
- D: Search optimization service
Question 57
What does a Notify & Suspend action for a resource monitor do?
- A: Send an alert notification to all account users who have notifications enabled.
- B: Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.
- C: Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.
- D: Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.
Question 58
How a Snowpipe charges calculated?
- A: Per-second/per Warehouse size
- B: Per-second/per-core granularity
- C: Number of Pipes in account
- D: Total storage bucket size
Question 59
When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
- A: The database owner
- B: The object owner
- C: The schema owner
- D: The Snowflake user's role
Question 60
How can a Snowsight user change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse?
- A: Use the ALTER WAREHOUSE command on an active Standard virtual warehouse.
- B: Use the ALTER WAREHOUSE command on an active Snowpark-optimized warehouse.
- C: Use the ALTER WAREHOUSE command on a suspended Standard virtual warehouse.
- D: Use the ALTER WAREHOUSE command on a suspended Snowpark-optimized warehouse.
Question 61
According to best practices, which table type should be used if the data can be recreated outside of Snowflake?
- A: Permanent table
- B: Temporary table
- C: Transient table
- D: Volatile table
Question 62
Which function unloads data from a relational table to JSON?
- A: TO_OBJECT
- B: TO_JSON
- C: TO_VARIANT
- D: OBJECT_CONSTRUCT
Question 63
What is the purpose of the STRIP_NULL_VALUES file format option when loading semi-structured data files into Snowflake?
- A: It removes null values from all columns in the data.
- B: It converts null values to empty strings during loading.
- C: It skips rows with null values during the loading process.
- D: It removes object or array elements containing null values.
Question 64
Which Snowflake edition enables data sharing only through Snowflake Support?
- A: Virtual Private Snowflake
- B: Business Critical
- C: Enterprise
- D: Standard
Question 65
What is the primary purpose of partitioning staged data files for regular data loads?
- A: To improve the performance of data loads
- B: To compress the data for efficient storage
- C: To encrypt the data for enhanced security
- D: To organize the data into subfolders for easy browsing
Question 66
What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?
- A: Standard Edition
- B: Enterprise Edition
- C: Business Critical Edition
- D: Virtual Private Snowflake Edition
Question 67
What can a Snowflake user do to reduce queuing on a multi-cluster virtual warehouse?
- A: Increase the warehouse size.
- B: Use an economy scaling policy.
- C: Increase the maximum number of clusters.
- D: Convert the warehouse to a Snowpark-optimized warehouse.
Question 68
Which statements describe benefits of Snowflake's separation of compute and storage? (Choose two.)
- A: The separation allows independent scaling of computing resources.
- B: The separation ensures consistent data encryption across all virtual data warehouses.
- C: The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.
- D: Storage volume growth and compute usage growth can be tightly coupled.
- E: Compute can be scaled up or down without the requirement to add more storage.
Question 69
True or False: A Snowflake account is charged for data stored in both Internal and External Stages.
- A: True
- B: False
Question 70
What should be used to show the status of partial data loads and loading errors?
- A: The COPY_HISTORY function
- B: The QUERY_HISTORY function
- C: The ACCESS_HISTORY view
- D: The WAREHOUSE_LOAD_HISTORY function
Question 71
What transformations are supported when loading data into a table using the COPY INTO [table] command? (Choose two.)
- A: Column reordering
- B: Column omission
- C: JOIN function
- D: FLATTEN function
- E: GROUP BY function
Question 72
Which object can be used with Secure Data Sharing?
- A: View
- B: Materialized view
- C: External table
- D: User-Defined Function (UDF)
Question 73
Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?
- A: DATA_RETENTION_TIME_IN_DAYS
- B: MAX_DATA_EXTENSION_TIME_IN_DAYS
- C: MIN_DATA_RETENTION_TIME_IN_DAYS
- D: MAX_CONCURRENCY_LEVEL
Question 74
Which commands are restricted in owner's rights stored procedures? (Choose two.)
- A: SHOW
- B: MERGE
- C: INSERT
- D: DELETE
- E: DESCRIBE
Question 75
What is the relationship between a Query Profile and a virtual warehouse?
- A: A Query Profile can help users right-size virtual warehouses.
- B: A Query Profile defines the hardware specifications of the virtual warehouse.
- C: A Query Profile can help determine the number of virtual warehouses available.
- D: A Query Profile automatically scales the virtual warehouse based on the query complexity.
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!