Loading questions...
Updated
Which methods can be used to create a DataFrame object in Snowpark? (Choose three.)
A Data Engineer has created a scalar User-Defined Function (UDF) that contains a SELECT statement based on a projection constraint column. The Engineer notices that the UDF behaves differently depending on how it is being used.
What are the expected behaviors of the UDF for the named context? (Choose two.)
A new CUSTOMER table is created by a data pipeline in a Snowflake schema where MANAGED ACCESS is enabled.
Which roles can grant access to the CUSTOMER table? (Choose three.)
What is the purpose of the BUILD_STAGE_FILE_URL function in Snowflake?
The JSON below is stored in a VARIANT column named V in a table named jCustRaw:
A company has an extensive script in Scala that transforms data by leveraging DataFrames. A Data Engineer needs to move these transformations to Snowpark.
What characteristics of data transformations in Snowpark should be considered to meet this requirement? (Choose two.)
The following is returned from SYSTEM$CLUSTERING_INFORMATION() for a table named ORDERS with a DATE column named O_ORDERDATE:
A company is building a dashboard for thousands of Analysts. The dashboard presents the results of a few summary queries on tables that are regularly updated. The query conditions vary by topic according to what data each Analyst needs. Responsiveness of the dashboard queries is a top priority, and the data cache should be preserved.
How should the Data Engineer configure the compute resources to support this dashboard?
A Data Engineer has developed a dashboard that will issue the same SQL select clause to Snowflake every 12 hours.
How long will Snowflake use the persisted query results from the result cache, provided that the underlying data has not changed?
A Data Engineer ran a stored procedure containing various transactions. During the execution, the session abruptly disconnected, preventing one transaction from committing or rolling back. The transaction was left in a detached state and created a lock on resources.
What step must the Engineer take to immediately run a new transaction?
A database contains a table and a stored procedure defined as:
How can the following relational data be transformed into semi-structured data using the LEAST amount of operational overhead?
When would a Data Engineer use TABLE with the FLATTEN function instead of the LATERAL FLATTEN combination?
Create a free account to unlock all questions for this exam.
Log In / Sign UpA Data Engineer is investigating a query that is taking a long time to return. The Query Profile shows the following:
What step should the Engineer take to increase the query performance?
Which query will return one row per team member (stored in the teamMembers array) along with all of the attributes of each team member?
What does the total_constant_partition_count value indicate about this table?
The log_table is initially empty and a Data Engineer issues the following command:
CALL insert_log(NULL::VARCHAR);
No other operations are affecting the log_table.
What will be the outcome of the procedure call?