- All Exams Instant Download
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?A . STATEMENT_TIMEOUT__IN__SECONDSB . STATEMENT_QUEUED_TIMEOUT_IN_SECONDSC . MAX_CONCURRENCY__LEVELD . QUERY_TIMEOUT_IN_SECONDSView AnswerAnswer: B Explanation: The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get...
What features does Snowflake Time Travel enable?
What features does Snowflake Time Travel enable?A . Querying data-related objects that were created within the past 365 daysB . Restoring data-related objects that have been deleted within the past 90 daysC . Conducting point-in-time analysis for Bl reportingD . Analyzing data usage/manipulation over all periods of timeView AnswerAnswer: B...
Which Snowflake feature is used for both querying and restoring data?
Which Snowflake feature is used for both querying and restoring data?A . Cluster keysB . Time TravelC . Fail-safeD . CloningView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/data-availability.html#:~:text=Snowflake%20provides%20powerful%20CDP%20features,days%20through%20Snowflake%20Time%20Travel.
How would you determine the size of the virtual warehouse used for a task?
How would you determine the size of the virtual warehouse used for a task?A . Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of executionB . Querying (select) the size of the stream content...
Which feature is only available in the Enterprise or higher editions of Snowflake?
Which feature is only available in the Enterprise or higher editions of Snowflake?A . Column-level securityB . SOC 2 type II certificationC . Multi-factor Authentication (MFA)D . Object-level access controlView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/intro-editions.html
Which application will the Snowflake users need to install on their devices in order to connect with MFA?
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake. Which application will the Snowflake users need to install on their devices in order to connect with MFA?A . Okta VerifyB . Duo MobileC...
True or False: Fail-safe can be disabled within a Snowflake account.
True or False: Fail-safe can be disabled within a Snowflake account.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach....
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
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 parameterC . Via SQL commandsD . Via Virtual WarehousesView AnswerAnswer: AC Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html
Which command can be used to view the list of files that has been uploaded to the staged?
A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?A . list @mytable; B. list @%raytable; C. list @ %m.ystage; D. list @mystage;View AnswerAnswer: D
Which of the following can be executed/called with Snowpipe?
Which of the following can be executed/called with Snowpipe?A . A User Defined Function (UDF) B. A stored procedure C. A single copy_into statement D. A single insert__into statementView AnswerAnswer: C
