Streams can be configured to query change data on which Snowflake objects? (Choose two.)
APipe
BStage
CSecure view
DMaterialized view
EShared table
Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?
AArea chart
BBox plot
CHeat grid
DPie chart
What does a Notify & Suspend action for a resource monitor do?
ASend an alert notification to all account users who have notifications enabled.
BSend an alert notification to all virtual warehouse users when thresholds over 100% have been met.
CSend 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.
DSend a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.
In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?
AREAD
BREFERENCES
CREFERENCE_USAGE
DUSAGE
Which types of subqueries does Snowflake support? (Choose two.)
AUncorrelated scalar subqueries in WHERE clauses
BUncorrelated scalar subqueries in any place that a value expression can be used
CEXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be uncorrelated only
DEXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated only
EEXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated
What is the PRIMARY factor that determines the cost of using a virtual warehouse in Snowflake?
AThe type of SQL statements executed
BThe number of tables or databases queried
CThe amount of data stored in the warehouse
DThe length of time the compute resources in each cluster run
Which governance feature is supported by all Snowflake editions?
AObject tags
BMasking policies
CRow access policies
DOBJECT_DEPENDENCIES view
A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.
What table type should be used?
APermanent
BTransient
CTemporary
DExternal
When does a materialized view get suspended in Snowflake?
AWhen a column is added to the base table
BWhen a column is dropped from the base table
CWhen a DML operation is run on the base table
DWhen the base table is reclustered
Which function returns the URL of a stage using the stage name as the input?
ABUILD_STAGE_FILE_URL
BBUILD_SCOPED_FILE_URL
CGET_PRESIGNED_URL
DGET_STAGE_LOCATION
What happens when a suspended virtual warehouse is resized in Snowflake?
AIt will return an error.
BIt will return a warning.
CThe suspended warehouse is resumed and new compute resources are provisioned immediately.
DThe additional compute resources are provisioned when the warehouse is resumed.
How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?
AACCESS_HISTORY
BLOAD_HISTORY
CQUERY_HISTORY
DREST_EVENT_HISTORY
The property MINS_TO_BYPASS_NETWORK_POLICY is set at which level?
AUser
BRole
CAccount
DOrganization
Which pages are included in the Activity area of Snowsight? (Choose two.)
AContacts
BSharing settings
CCopy History
DQuery History
EAutomatic Clustering History
What command is used to export or unload data from Snowflake?
APUT @mystage
BGET @mystage
CCOPY INTO @mystage
DINSERT @mystage
Which Query Profile category displays the time spent setting up the query processing?
AInitialization
BProcessing
CSynchronization
DLocal Disk IO
Which function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs, with a file URL that does not expire?
ABUILD_SCOPED_FILE_URL
BBUILD_STAGE_FILE_URL
CGET_ABSOLUTE_PATH
DGET_PRESIGNED_URL
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?
ADATA_RETENTION_TIME_IN_DAYS
BMAX_DATA_EXTENSION_TIME_IN_DAYS
CMIN_DATA_RETENTION_TIME_IN_DAYS
DMAX_CONCURRENCY_LEVEL
At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
AAccount
BDatabase
CSchema
DTable
What type of function returns one value for each invocation?
AAggregate
BScalar
CTable
DWindow
What persistent data structures are used by the search optimization service to improve the performance of point lookups?
AMicro-partitions
BClustering keys
CEquality searches
DSearch access paths
A Snowflake user is actively logged into Snowflake when a user-level network policy is assigned to that user.
What will Snowflake do if the user's IP address does not match the user-level network policy rules?
ALog the user out.
BDeactivate the network policy.
CPrevent the user from executing additional queries.
DAllow the user to continue until the session or login token expires.
When a Snowflake user loads CSV data from a stage, which COPY INTO <table> command guideline should they follow?
AThe CSV field delimiter must be a comma character (',').
BThe number of columns in each row should be consistent.
CThe data file in the stage must be in a compressed format.
DThe data file must have the same number of columns as the target table.
Which statements describe benefits of Snowflake's separation of compute and storage? (Choose two.)
AThe separation allows independent scaling of computing resources.
BThe separation ensures consistent data encryption across all virtual data warehouses.
CThe separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.
DStorage volume growth and compute usage growth can be tightly coupled.
ECompute can be scaled up or down without the requirement to add more storage.
Preview
