Question 1

While loading CSV data using the COPY INTO statement, a Data Engineer encounters the following error.Number of columns in file (15) does not match that of the corresponding table (14)Which approach should the Data Engineer take to solve this problem and load all the fields in the file into the table? (Choose two.)

Options :

A : Make necessary changes in the table DDL to support all the columns in the file.

B : Set the copy option FORCE to true.

C : Modify the file data to use a different file format. Change the file format type in the file format options during the loading process.

D : Modity the file data to enclose fields with a delimiter. Leverage the FIELD_OPTIONALLY_ENCLOSED_BY option in the file format during the load process.

E : Do not modify the file data. Change the ERROR_ON_COLUMN_COUNT_MISMATCH option in the file format to false during the loading process.

Answer: A,E

Question 2

A data platform team creates two multi-cluster virtual warehouses with the AUTO_SUSPEND value set to NULL on one. and '0' on the other. What would be the execution behavior of these virtual warehouses?

Options :

A : Setting a '0' or NULL value means the warehouses will never suspend.

B : Setting a '0' or NULL value means the warehouses will suspend immediately.

C : Setting a '0' or NULL value means the warehouses will suspend after the default of 600 seconds.

D : Setting a '0' value means the warehouses will suspend immediately, and NULL means the warehouses will never suspend.

Answer: D

Question 3

A company is designing high availability and disaster recovery plans and needs to maximize redundancy and minimize recovery time objectives for their critical application processes. Cost is not a concern as long as the solution is the best available. The plan so far consists of the following steps: 1. Deployment of Snowflake accounts on two different cloud providers. 2. Selection of cloud provider regions that are geographically far apart. 3. The Snowflake deployment will replicate the databases and account data between both cloud provider accounts. 4. Implementation of Snowflake client redirect. What is the MOST cost-effective way to provide the HIGHEST uptime and LEAST application disruption if there is a service event?

Options :

A : Connect the applications using the - URL. Use the Business Critical Snowflake edition.

B : Connect the applications using the - URL. Use the VirtualPrivate Snowflake (VPS) edition.

C : Connect the applications using the - URL. Use the Enterprise Snowflake edition.

D : Connect the applications using the - URL. Use the Business Critical Snowflake edition.

Answer: D

Question 4

An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00AM, 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 Architect receives the following error: Time travel data is not available for schema STAGING. Therequested time is either beyond the allowed time travel period or before the object creation time.The Architect then checks the schema history and sees the following:CREATED_ON|NAME|DROPPED_ON2021-06-02 23:00:00 | STAGING | NULL2021-05-01 10:00:00 | STAGING | 2021-06-02 23:00:00How can cloning the STAGING schema be achieved?

Options :

A : Undrop the STAGING schema and then rerun the CLONE statement.

B : Modify the statement: CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-05-01 10:00:00');

C : Rename the STAGING schema and perform an UNDROP to retrieve the previous STAGING schema version, then run the CLONE statement.

D : Cloning cannot be accomplished because the STAGING schema version was not active during the proposed Time Travel time period.

Answer: D

Question 5

A company has several sites in different regions from which the company wants to ingest data. Which of the following will enable this type of data ingestion?

Options :

A : The company must have a Snowflake account in each cloud region to be able to ingest data to that account.

B : The company must replicate data between Snowflake accounts.

C : The company should provision a reader account to each site and ingest the data through the reader accounts.

D : The company should use a storage integration for the external stage.

Answer: D

Free SnowPro-Advanced-Architect Mock Exam – Practice Online Confidently

Buying Options: