- All Exams Instant Download
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 integration object should be used to place restrictions on where data may be exported?
What integration object should be used to place restrictions on where data may be exported?A . Stage integrationB . Security integrationC . Storage integrationD . API integrationView AnswerAnswer: C
Which of the below commands will use warehouse credits?
Which of the below commands will use warehouse credits?A . SHOW TABLES LIKE 'SNOWFL%';B . SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;C . SELECT COUNT(*) FROM SNOWFLAKE;D . SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;View AnswerAnswer: B,C,D Explanation: All the SELECT queries will use warehouse credits because they involve processing data, which requires...
With default settings for multi cluster warehouse, how does snowflake determines when to start a new cluster?
With default settings for multi cluster warehouse, how does snowflake determines when to start a new cluster?A . Immediately when either a query is queued or the system detects that there’s one more query than the currently-running clusters can executeB . Only if the system estimates there’s enough query load...
Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?
An Architect is designing a pipeline to stream event data into Snowflake using the Snowflake Kafka connector. The Architect’s highest priority is to configure the connector to stream data in the MOST cost-effective manner. Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?A...
What would cause this to occur?
A DevOps team has a requirement for recovery of staging tables used in a complex set of data pipelines. The staging tables are all located in the same staging schema. One of the requirements is to have online recovery of data on a rolling 7-day basis. After setting up the...
Which approach will meet these requirements if Role-Based Access Policies (RBAC) is a viable option for isolating tenants?
A Snowflake Architect is designing an application and tenancy strategy for an organization where strong legal isolation rules as well as multi-tenancy are requirements. Which approach will meet these requirements if Role-Based Access Policies (RBAC) is a viable option for isolating tenants?A . Create accounts for each tenant in the...
Where can you define the file format settings?
Where can you define the file format settings?A . While creating named file formatsB . In the table definitionC . In the named stage definitionD . Directly in the COPY INTO TABLE statement when loading dataView AnswerAnswer: A,D Explanation: File format settings can be defined when creating a named file...
When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?
When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?A . CONTINUEB . SKIP_FILEC . ABORT_STATEMENTD . FAILView AnswerAnswer: A,B,C Explanation: Copy Options (copyOptions) You can specify one or more of the following copy options (separated by blank spaces, commas, or new lines):...
Assuming the syntax is correct, what is the cause of this error?
Consider the following COPY command which is loading data with CSV format into a Snowflake table from an internal stage through a data transformation query. This command results in the following error: SQL compilation error: invalid parameter 'validation_mode' Assuming the syntax is correct, what is the cause of this error?A...
