- All Exams Instant Download
How does a standard virtual warehouse policy work in Snowflake?
How does a standard virtual warehouse policy work in Snowflake?A . It conserves credits by keeping running clusters fully loaded rather than starting additional clusters.B . It starts only if the system estimates that there is a query load that will keep the cluster busy for at least 6 minutes.C...
Assuming MY_WH is set to auto_suspend C 60 and used exclusively for this task, which statement is true?
The following DDL command was used to create a task based on a stream: Assuming MY_WH is set to auto_suspend C 60 and used exclusively for this task, which statement is true?A . The warehouse MY_WH will be made active every five minutes to check the stream.B . The warehouse...
Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)
Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)A . Changing the name of the organizationB . Creating an accountC . Viewing a list of organization accountsD . Changing the name of an accountE . Deleting an accountF . Enabling the replication of a databaseView AnswerAnswer: B,...
Which Snowflake data modeling approach is designed for BI queries?
Which Snowflake data modeling approach is designed for BI queries?A . 3NFB . Star schemaC . Data VaultD . Snowflake schemaView AnswerAnswer: B Explanation: A star schema is a Snowflake data modeling approach that is designed for BI queries. A star schema is a type of dimensional modeling that organizes...
If the user loads this column data into another column that does not have a masking policy, what will occur?
A user has the appropriate privilege to see unmasked data in a column. If the user loads this column data into another column that does not have a masking policy, what will occur?A . Unmasked data will be loaded in the new column.B . Masked data will be loaded into...
Which design will meet these requirements?
A media company needs a data pipeline that will ingest customer review data into a Snowflake table, and apply some transformations. The company also needs to use Amazon Comprehend to do sentiment analysis and make the de-identified final data set available publicly for advertising companies who use different cloud providers...
Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)
Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)A . Choose columns that are frequently used in join predicates.B . Choose lower cardinality columns to support clustering keys and cost effectiveness.C . Choose TIMESTAMP columns with nanoseconds for the highest number of unique rows.D ....
What Snowflake functionality should be used to meet these requirements?
A company wants to deploy its Snowflake accounts inside its corporate network with no visibility on the internet. The company is using a VPN infrastructure and Virtual Desktop Infrastructure (VDI) for its Snowflake users. The company also wants to re-use the login credentials set up for the VDI to eliminate...
What are some of the characteristics of result set caches? (Choose three.)
What are some of the characteristics of result set caches? (Choose three.)A . Time Travel queries can be executed against the result set cache.B . Snowflake persists the data results for 24 hours.C . Each time persisted results for a query are used, a 24-hour retention period is reset.D ....
What should the Architect do to enable the Snowflake search optimization service on this table?
An Architect has a VPN_ACCESS_LOGS table in the SECURITY_LOGS schema containing timestamps of the connection and disconnection, username of the user, and summary statistics. What should the Architect do to enable the Snowflake search optimization service on this table?A . Assume role with OWNERSHIP on future tables and ADD SEARCH...
