A. TABLE STREAM
B. COPY INTO
C. INSERT INTO
D. CREATE PIPE
A. Access Snowflake Marketplace to find and integrate datasets.
B. Explore each step of an executed query.
C. Create and manage user roles and permissions.
D. Monitor queries executed by users in an account.
E. Schedule automated data backups.
A. All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
B. Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
C. Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.
D. Snowflake data and services are deployed in at least three availability zones within a cloud provider's region
E. Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage
F. Snowflake data and services are deployed in a single availability zone within a cloud provider's region.
A. USAGE_VIEWER
B. OBJECT_VIEWER
C. SECURITY_VIEWER
D. GOVERNANCE_VIEWER
A. VARIANT
B. VARCHAK
C. BINARY
D. TEXT
E. ARRAY
A. SELECT * FROM MY_TABLE SAMPLE SYSTEM (5);
B. SELECT * FROM MY_TABLE SAMPLE BERNOULLI (5);
C. SELECT * FROM MY_TABLE SAMPLE (5 ROWS);
D. SELECT * FROM MY_TABLE SAMPLE SYSTEM (1) SEED (5);
A. Secure views are similar to materialized views in that they are the most performant.
B. Secure views execute slowly compared to non-secure views.
C. Non-secure views are preferred over secure views when sharing data.
D. There are no performance differences between secure and non-secure views.
A. Auto-scale mode
B. Maximized mode
C. A standard scaling policy
D. An economy scaling policy
A. 256
B. 64
C. 10
D. 50
A. COPY_HISTORY
B. ROW ACCESS POLICIES
C. QUERY_HISTORY
D. ACCESS_HISTORY
A. Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 365 days.Fail Safe retention time is 7 days.
B. Default Time Travel Retention is set to 7 days.Maximum Time Travel Retention is 1 day.Fail Safe retention time is 90 days.
C. Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.
D. Default Time Travel Retention is set to 90 days.Maximum Time Travel Retention is 7 days.Fail Safe retention time is 356 days.
E. Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 30 days.Fail Safe retention time is 1 day.
F. Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.
A. 1 hour
B. 2 hours
C. 8 hours
D. 4 hours
A. Column omission
B. Column aggregation
C. Selection of a limited number of rows
D. Column reordering
E. Column grouping
A. They are a set of rules that control access to Snowflake accounts by specifying the IP addresses or ranges of IP addresses that are allowed to connect to Snowflake.
B. They are a set of rules that define the network routes within Snowflake.
C. They are a set of rules that define how data can be transferred between different Snowflake accounts within an organization.
D. They are a set of rules that dictate how Snowflake accounts can be used between multiple users.
A. Information schema views are read-only but account usage views are not.
B. Account usage views do not contain data about tables but information schema views do.
C. Account issue views contain dropped objects but information schema views do not.
D. Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.
E. No active warehouse to needed to query account usage views but one is needed to query information schema views.
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.
