- All Exams Instant Download
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...
Which command can be run to list all shares that have been created in your account or are available to consume by your account
Which command can be run to list all shares that have been created in your account or are available to consume by your accountA . SHOW SHARESB . LIST SHARESC . DESCRIBE SHARESView AnswerAnswer: A Explanation: SHOW SHARES Lists all shares available in the system: Outbound shares (to consumers) that...
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 security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)
Which security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)A . Extended Time Travel (up to 90 days)B . Customer-managed encryption keys through Tri-Secret SecureC . Periodic rekeying of encrypted dataD . AWS, Azure, or Google Cloud private connectivity to SnowflakeE...
A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view uses
A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view usesA . TRUEB . FALSEView AnswerAnswer: A Explanation: A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view...
Which actions can the company take with the inbound share?
A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines. Which actions can the company take with the inbound share? (Choose two.)A . Clone a table from a share.B . Grant modify...
