According to Snowflake recommended best practice, how should these requirements be met?

A large manufacturing company runs a dozen individual Snowflake accounts across its business divisions. The company wants to increase the level of data sharing to support supply chain optimizations and increase its purchasing leverage with multiple vendors. The company’s Snowflake Architects need to design a solution that would allow the...

May 31, 2023 No Comments READ MORE +

What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULL

What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULLA . An error is returned and no changes are applied to the column B. Snowflake automatically assigns a default value and let the change happen C. Snowflake drops the row and...

May 31, 2023 No Comments READ MORE +

How will you resume it?

You have created a TASK in snowflake. How will you resume it?A . No need to resume, the creation operation automatically enables the task B. ALTER TASK mytask1 RESUME; C. ALTER TASK mytask1 START;View AnswerAnswer: B Explanation: It is important to remember that a Task that has just been created...

May 31, 2023 No Comments READ MORE +

What is the most optimal solution that you will suggest to the business team?

You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the...

May 31, 2023 No Comments READ MORE +

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...

May 31, 2023 No Comments READ MORE +

Where can you define the file format settings?

Where can you define the file format settings?A . While creating named file formats B. In the table definition C. In the named stage definition D. Directly in the COPY INTO TABLE statement when loading dataView AnswerAnswer: A,B,C,D Explanation: Snowflake supports creating named file formats, which are database objects that...

May 31, 2023 No Comments READ MORE +

You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Everyday new data comes in and the old data is no longer required.

You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Everyday new data comes in and the old data is no longer required. What type of table you will...

May 31, 2023 No Comments READ MORE +

Which copy options are not supported by CREATE PIPE...AS COPY FROM command?

Which copy options are not supported by CREATE PIPE...AS COPY FROM command?A . FILES = ( 'file_name1' [ , 'file_name2', ... ] ) B. FORCE = TRUE | FALSE C. ON_ERROR = ABORT_STATEMENT D. VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS E. MATCH_BY_COLUMN_NAME = CASE_SENSITIVE | CASE_INSENSITIVE | NONEView AnswerAnswer:...

May 31, 2023 No Comments READ MORE +

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...

May 31, 2023 No Comments READ MORE +

How can cloning the STAGING schema be achieved?

An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00 AM, to recover some objects. The STAGING schema has 50 days of retention. The Architect runs the following statement: CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-06-01 08:00:00'); The...

May 30, 2023 No Comments READ MORE +