- All Exams Instant Download
What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?
What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?A . INITTIALLY_SUSPENDED = TRUE/FALSEB . START_AFTCR_CREATE = TRUE/FALSEC . START_TTIME = 60 // (seconds from now)D . STARE . TIME = CURRENF . DATE()View AnswerAnswer: A
True or False: You can define multiple columns within a clustering key on a table.
True or False: You can define multiple columns within a clustering key on a table.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
Which statement about billing applies to Snowflake credits?
Which statement about billing applies to Snowflake credits?A . Credits are billed per-minute with a 60-minute minimumB . Credits are used to pay for cloud data storage usageC . Credits are consumed based on the number of credits billed for each hour that a warehouse runsD . Credits are consumed...
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)A . JDBCB . SnowSQLC . Snowflake Web Interface (UI)D . ODBCE . PythonView AnswerAnswer: A,B,C,D,E Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html
How long is Snowpipe data load history retained?
How long is Snowpipe data load history retained?A . As configured in the create pipe settingsB . Until the pipe is droppedC . 64 daysD . 14 daysView AnswerAnswer: C Explanation: Bulk data load Stored in the metadata of the target table for 64 days. Available upon completion of the...
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?A . To accommodate more queriesB . To accommodate more usersC . To accommodate fluctuations in workloadD . To accommodate a more complex workloadView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html
What Snowflake role must be granted for a user to create and manage accounts?
What Snowflake role must be granted for a user to create and manage accounts?A . ACCOUNTADMINB . ORGADMINC . SECURITYADMIND . SYSADMINView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
True or False: Snowpipe via RFST API can only reference External Stages as source.
True or False: Snowpipe via RFST API can only reference External Stages as source.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default
True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.
True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.A . TrueB . FalseView AnswerAnswer: A Explanation: Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.
How often are encryption keys automatically rotated by Snowflake?
How often are encryption keys automatically rotated by Snowflake?A . 30 DaysB . 60 DaysC . 90 DaysD . 365 DaysView AnswerAnswer: A Explanation: All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When...
