- All Exams Instant Download
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...
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...
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:...
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...
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...
While choosing a cluster key, what is recommended by snowflake?
While choosing a cluster key, what is recommended by snowflake?A . Cluster columns that are most actively used in selective filters B. If there is room for additional cluster keys, then consider columns frequently used in join predicates C. Choose a key with high cardinalityView AnswerAnswer: A,B Explanation: Snowflake recommends...
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...
Loading data using snowpipe REST API is supported for external stage only
Loading data using snowpipe REST API is supported for external stage onlyA . TRUE B. FALSEView AnswerAnswer: B Explanation: Snowpipe supports loading from the following stage types:
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 . TRUE B. 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...
What configuration can the company’s Architect implement to enhance the performance of this workload?
A company’s daily Snowflake workload consists of a huge number of concurrent queries triggered between 9pm and 11pm. At the individual level, these queries are smaller statements that get completed within a short time period. What configuration can the company’s Architect implement to enhance the performance of this workload? (Choose...
