QUESTION 16
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 schem a. One of the requirements is to have online recovery of data on a rolling 7-day basis.
After setting up the DATA_RETENTION_TIME_IN_DAYS at the database level, certain tables remain unrecoverable past 1 day.
What would cause this to occur? (Choose two.)

QUESTION 17
An Architect needs to meet a company requirement to ingest files from the company’s AWS storage accounts into the company’s Snowflake Google Cloud Platform (GCP) account. How can the ingestion of these files into the company’s Snowflake account be initiated? (Select TWO).

QUESTION 18
An Architect needs to meet a company requirement to ingest files from the company’s AWS storage accounts into the company’s Snowflake Google Cloud Platform (GCP) account. How can the ingestion of these files into the company’s Snowflake account be initiated? (Select TWO).

QUESTION 19
Files stored in snowflake internal stage are automatically encrypted using either AES 128 or 256 strong encryption.

QUESTION 20
An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The Architect fixes the file and re-loads it to the stage with the exact same file name it had previously.
Which commands should the Architect use to load only file5.csv file from the stage? (Choose two.)

QUESTION 21
How can the Snowpipe REST API be used to keep a log of data load history?

QUESTION 22
Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)

QUESTION 23
Data replication in snowflake helps in

QUESTION 24
What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?

QUESTION 25
What is the best practice to follow when calling the SNOWPIPE REST API loadHistoryScan

QUESTION 26
The Data Engineering team at a large manufacturing company needs to engineer data coming from many sources to support a wide variety of use cases and data consumer requirements which include:
1) Finance and Vendor Management team members who require reporting and visualization
2) Data Science team members who require access to raw data for ML model development
3) Sales team members who require engineered and protected data for data monetization What Snowflake data modeling approaches will meet these requirements? (Choose two.)

QUESTION 27
What step will improve the performance of queries executed against an external table?

QUESTION 28
The Business Intelligence team reports that when some team members run queries for their dashboards in parallel with others, the query response time is getting significantly slower What can a Snowflake Architect do to identify what is occurring and troubleshoot this issue?

QUESTION 29
A user needs access to create materialized view on a shema mydb.myschema.
What is the appropriate command to provide the access?

QUESTION 30
What is the data size limit for loading into a variant column?

QUESTION 31
An Architect has a design where files arrive every 10 minutes and are loaded into a primary database table using Snowpipe. A secondary database is refreshed every hour with the latest data from the primary database.
Based on this scenario, what Time Travel query options are available on the secondary database?

QUESTION 32
How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)

QUESTION 33
A new table and streams are created with the following commands:
CREATE OR REPLACE TABLE LETTERS (ID INT, LETTER STRING) ;
CREATE OR REPLACE STREAM STREAM_1 ON TABLE LETTERS;
CREATE OR REPLACE STREAM STREAM_2 ON TABLE LETTERS APPEND_ONLY = TRUE;
The following operations are processed on the newly created table:
INSERT INTO LETTERS VALUES (1, ‘A’);
INSERT INTO LETTERS VALUES (2, ‘B’);
INSERT INTO LETTERS VALUES (3, ‘C’);
TRUNCATE TABLE LETTERS;
INSERT INTO LETTERS VALUES (4, ‘D’);
INSERT INTO LETTERS VALUES (5, ‘E’);
INSERT INTO LETTERS VALUES (6, ‘F’);
DELETE FROM LETTERS WHERE ID = 6;
What would be the output of the following SQL commands, in order?
SELECT COUNT (*) FROM STREAM_1;
SELECT COUNT (*) FROM STREAM_2;

QUESTION 34
Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)

QUESTION 35
Which of the below commands will use warehouse credits?

QUESTION 36
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.)

QUESTION 37
A company is using a Snowflake account in Azure. The account has SAML SSO set up using ADFS as a SCIM identity provider. To validate Private Link connectivity, an Architect performed the following steps:
* Confirmed Private Link URLs are working by logging in with a username/password account
* Verified DNS resolution by running nslookups against Private Link URLs
* Validated connectivity using SnowCD
* Disabled public access using a network policy set to use the company’s IP address range However, the following error message is received when using SSO to log into the company account:
IP XX.XXX.XX.XX is not allowed to access snowflake. Contact your local security administrator.
What steps should the Architect take to resolve this error and ensure that the account is accessed using only Private Link? (Choose two.)

QUESTION 38
You have a medium warehouse with auto suspend of 5 minutes. You ran a query on table#1. After 10 minutes, you ran a query that joins table#1 and table#2, but you see that the query did not use data
cache.
Why?