QUESTION 56
A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is considering using an Account Per Tenant strategy.
Which requirements will be addressed with this approach? (Choose two.)

QUESTION 57
Removing files from a stage after you are done loading the files improves performance when subsequently loading data

QUESTION 58
What is a valid object hierarchy when building a Snowflake environment?

QUESTION 59
Which of the below approach results in perfromance improvement through linear scaling of data ingestion workload?

QUESTION 60
The endpoint insertFiles of SnowPipe rest API is used to inform Snowflake about the files to be ingested into a table. Select the two statements for this end point.

QUESTION 61
You have a table named JSON_TBL which has a variant column JSON_VAR. The json stored in that table looks as below
{
“COURSE_DESC”: “SNOWFLAKE CERTIFICATION”,
“COURSE_ID”: 1000,
“DURATION”: 2
}
if you run a query SELECT JSON_VAR:Course_id FROM JSON_TBL; what will it return

QUESTION 62
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 63
A user needs access to create materialized view on a shema mydb.myschema.
What is the appropriate command to provide the access?

QUESTION 64
Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?

QUESTION 65
Which of the below are securable objects?

QUESTION 66
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 67
Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)

QUESTION 68
When a cloned table is replicated to a secondary database, the data also gets replicated in the secondary database

QUESTION 69
In the default access control hierarchy, both securityadmin and sysadmin are owned by accountadmin

QUESTION 70
Data loading transformation as part of copying data to a table from stage supports selecting data from user stage and named stages(internal and external) only

QUESTION 71
To convert JSON null value to SQL null value, you will use

QUESTION 72
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?

QUESTION 73
When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?

QUESTION 74
SNOWPIPE_AUTO_INGEST is supported for external stages only

QUESTION 75
The following DDL command was used to create a task based on a stream:

Assuming MY_WH is set to auto_suspend – 60 and used exclusively for this task, which statement is true?

QUESTION 76
Which Snowflake data modeling approach is designed for BI queries?