ExamFreeIT Certification Practice, Made Simple

Preparing Practice Exam…

Please wait a moment while the system generates the exam questions, answers, and study session.

ExamFree

Free practice questions with explanations for AWS, Microsoft, CompTIA, Google Cloud, PMI, and more.

Explore

Browse All Exams
About ExamFree
Telegram Support
Report a Question

Providers

Microsoft practice exams
Google Cloud practice exams
CompTIA practice exams
PMI practice exams
AWS practice exams
Databricks practice exams
Cisco practice exams
Snowflake practice exams
Anthropic practice exams
Linux Foundation practice exams
HashiCorp practice exams
ITIL practice exams
Red Hat practice exams

© 2026 ExamFree. ExamFree is an independent practice platform and is not affiliated with or endorsed by AWS, Microsoft, Google, CompTIA, PMI, or any certification provider. All certification names and trademarks belong to their respective owners.

Home/Exams/Snowflake/SNOW-DEA/Practice

SNOW-DEAActiveSnowflake · Advanced

SnowPro Advanced: Data Engineer Practice Mode

126 total questions·38 questions in free preview

Practice questions

Question 28 of 38

Free Preview · 38 of 126 · questions 1–38 of 126 are free. Sign up free to sync your progress across devices.

0 of 38 answered

Question Map

38 available

1 / 1

Question 28

View question permalink page

Flag question for review

Hot Area / Dropdown

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?

Hotspot Scenario

Select the appropriate option to complete the statement. Click Check Answer below to see the marked solution.

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

Chose B2
Definitely B. D gives a similar result but with double quotes.
Chose B2
Possibly B

28 / 38

Keyboard:←→ previous / nextA–E chooseEnter check, then next