00:00

QUESTION 16

The JSON below is stored in a variant column named v in a table named jCustRaw:
DEA-C01 dumps exhibit
Which query will return one row per team member (stored in the teamMembers array) along all of the attributes of each team member?
A)
DEA-C01 dumps exhibit
DEA-C01 dumps exhibit
C)
DEA-C01 dumps exhibit
D)
DEA-C01 dumps exhibit

Correct Answer: B

QUESTION 17

Which methods can be used to create a DataFrame object in Snowpark? (Select THREE)

Correct Answer: BCF
The methods that can be used to create a DataFrame object in Snowpark are session.read.json(), session.table(), and session.sql(). These methods can create a DataFrame from different sources, such as JSON files, Snowflake tables, or SQL queries.
The other options are not methods that can create a DataFrame object in Snowpark. Option A, session.jdbc_connection(), is a method that can create a JDBC connection object to connect to a database. Option D, DataFrame.write(), is a method that can write a DataFrame to a destination, such as a file or a table. Option E, session.builder(), is a method that can create a SessionBuilder object to configure and build a Snowpark session.