SnowPro Advanced Data Engineer Certification (DEA-C01) - Snowflake Actual Exam Questions
Last updated on May 13, 2026
A Data Engineer is working on a continuous data pipeline which receives data from Amazon Kinesis Firehose and loads the data into a staging table which will later be used in the data transformation process The average file size is 300-500 MB. The Engineer needs to ensure that Snowpipe is performant while minimizing costs. How can this be achieved?
Increase the size of the virtual warehouse used by Snowpipe.
Split the files before loading them and set the SIZE_LIMIT option to 250 MB.
Change the file compression size and increase the frequency of the Snowpipe loads
Decrease the buffer size to trigger delivery of files sized between 100 to 250 MB in Kinesis Firehose
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
What are characteristics of Snowpark Python packages? (Select THREE). Third-party packages can be registered as a dependency to the Snowpark session using the session, import () method.
Python packages can access any external endpoints
Python packages can only be loaded in a local environment
Third-party supported Python packages are locked down to prevent hitting
The SQL command DESCRIBE FUNCTION will list the imported Python packages of the Python User-Defined Function (UDF).
Querying information__schema .packages will provide a list of supported Python packages and versions
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Within a Snowflake account permissions have been defined with custom roles and role hierarchies. To set up column-level masking using a role in the hierarchy of the current user, what command would be used?
CORRECT_ROLE
IKVOKER_ROLE
IS_RCLE_IN_SESSION
IS_GRANTED_TO_INVOKER_ROLE
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
A new customer table is created by a data pipeline in a Snowflake schema where MANAGED ACCESS enabled. …. Can gran access to the CUSTOMER table? (Select THREE.)
The role that owns the schema
The role that owns the database
The role that owns the customer table
The SYSADMIN role
The SECURITYADMIN role
The USERADMIN role with the manage grants privilege
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
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 tope 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?
Assign queries to a multi-cluster virtual warehouse with economy auto-scaling Allow the system to automatically start and stop clusters according to demand.
Assign all queries to a multi-cluster virtual warehouse set to maximized mode Monitor to determine the smallest suitable number of clusters.
Create a virtual warehouse for every 250 Analysts Monitor to determine how many of these virtual warehouses are being utilized at capacity.
Create a size XL virtual warehouse to support all the dashboard queries Monitor query runtimes to determine whether the virtual warehouse should be resized.
to join the discussion
No discussions yet. Be the first to ask!
Delete Comment
Are you sure? This action cannot be undone.
Finish Practice?
Are you sure you want to finish? This will end your practice session.