SnowPro Advanced Data Engineer Practice Test

Question 26

Which methods will trigger an action that will evaluate a DataFrame? (Choose two.)

1. DataFrame.random_split()
2. DataFrame.collect()
3. DataFrame.select()
4. DataFrame.col()
5. DataFrame.show()

Question 27

Which Snowflake objects does the Snowflake Kafka connector use? (Choose three.)

1. Pipe
2. Serverless task
3. Internal user stage
4. Internal table stage
5. Internal named stage
6. Storage integration

Question 28

A Data Engineer has created table t1 with one column c1 with datatype VARIANT: create or replace table t1 (c1 variant); The Engineer has loaded the following JSON data set, which has information about 4 laptop models, into the table. The Engineer now wants to query that data set so that results are shown as normal structured data. The result should be 4 rows and 4 columns, without the double quotes surrounding the data elements in the JSON data. The result should be similar to the use case where the data was selected from a normal relational table t2, where t2 has string data type columns model_id, model, manufacturer, and model_name, and is queried with the SQL clause select * from t2; Which select command will produce the correct results?

Question 29

What is a characteristic of the use of external tokenization?

1. Secure data sharing can be used with external tokenization.
2. External tokenization cannot be used with database replication.
3. Pre-loading of unmasked data is supported with external tokenization.
4. External tokenization allows the preservation of analytical values after de-identification.

Question 30

A Data Engineer is implementing a near real-time ingestion pipeline to load data into Snowflake using the Snowflake Kafka connector. There will be three Kafka topics created. Which Snowflake objects are created automatically when the Kafka connector starts? (Choose three.)

1. Tables
2. Tasks
3. Pipes
4. Internal stages
5. External stages
6. Materialized views