Which of the following are characteristics of Snowflake's parameter hierarchy?

• A.Session parameters override virtual warehouse parameters.
• B.Virtual warehouse parameters override user parameters.
• C.Table parameters override virtual warehouse parameters.
• D.Schema parameters override account parameters.

Comment: *

Name: *

Email: *

Verification: *

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

• A.The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.
• B.The Connector creates and manages its own stage, file format, and pipe objects.
• C.Loads using the Connector will have lower latency than Snowpipe and will ingest data in real time.
• D.The Connector only works in Snowflake regions that use AWS infrastructure.

Comment: *

Name: *

Email: *

Verification: *

Which of the following ingestion methods can be used to load near real-time data by using the messaging services provided by a cloud provider?

• A.Snowflake streams
• B.Snowpipe
• C.Spark
• D.Snowflake Connector for Kafka

Comment: *

Name: *

Email: *

Verification: *

An Architect entered the following commands in sequence:

USER1 cannot find the table.
Which of the following commands does the Architect need to run for USER1 to find the tables using the Principle of Least Privilege? (Choose two.)

• A.GRANT ALL PRIVILEGES ON DATABASE SANDBOX TO ROLE INTERN;
• B.GRANT ROLE PUBLIC TO ROLE INTERN;
• C.GRANT USAGE ON SCHEMA SANDBOX.PUBLIC TO ROLE INTERN;
• D.GRANT USAGE ON DATABASE SANDBOX TO ROLE INTERN;
• E.GRANT OWNERSHIP ON DATABASE SANDBOX TO USER INTERN;

Comment: *

Name: *

Email: *

Verification: *

An Architect is designing a data lake with Snowflake. The company has structured, semi-structured, and unstructured data. The company wants to save the data inside the data lake within the Snowflake system. The company is planning on sharing data among its corporate branches using Snowflake data sharing.
What should be considered when sharing the unstructured data within Snowflake?

• A.A pre-signed URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with no time limit for the URL.
• B.A scoped URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with a 24-hour time limit for the URL.
• C.A file URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with a 7-day time limit for the URL.
• D.A file URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with the "expiration_time" argument defined for the URL time limit.

Comment: *

Name: *

Email: *

Verification: *