Snowflake DSA-C02 Free Sample Exam Questions 2026

Here you can get the actual Snowflake DSA-C02 exam questions and answers in PDF for free and for all questions premium file. These best SnowPro Advanced: Data Scientist Certification Exam DSA-C02 PDF questions are for every Snowflake users. Real DSA-C02 exam dumps that will assist you to crack the %certification% certification exam in the PDF format. For Advance preparation premium PDF files available for perfect exam preparation on reilable price option.

UNLOCK FULL
DSA-C02 Exam Features

In Just $35 You can Access

• All Official Question Types
• Interactive Web-Based Practice Test Software
• No Installation or 3rd Party Software Required
• Customize your practice sessions (Free Demo)
• 24/7 Customer Support

Get Full Access

Page: 1 / 13
Total Questions: 65

Questions & Answers PDF

• Question 1

  

  Which object records data manipulation language (DML) changes made to tables, including inserts, updates, and deletes, as well as metadata about each change, so that actions can be taken using the changed data of Data Science Pipelines?

  • Task
  • Dynamic tables
  • Stream
  • Tags
  • Delta
  • OFFSET

  Reveal Answer Answer: C Next Question

• Question 2

  

  You are training a binary classification model to support admission approval decisions for a college degree program.How can you evaluate if the model is fair, and doesn’t discriminate based on ethnicity?

  • Evaluate each trained model with a validation dataset and use the model with the highest accuracy score.
  • Remove the ethnicity feature from the training dataset.
  • Compare disparity between selection rates and performance metrics across ethnicities.
  • None of the above.

  Reveal Answer Answer: C Next Question

• Question 3

  

  Data providers add Snowflake objects (databases, schemas, tables, secure views, etc.) to a share us- ing Which of the following options?

  • Grant privileges on objects to a share via Account role.
  • Grant privileges on objects directly to a share.
  • Grant privileges on objects to a share via a database role.
  • Grant privileges on objects to a share via a third-party role.

  Reveal Answer Answer: B, ,C Next Question

• Question 4

  

  Which command manually triggers a single run of a scheduled task (either a standalone task or the root task in a DAG) independent of the schedule defined for the task?

  • RUN TASK
  • CALL TASK
  • EXECUTE TASK
  • RUN ROOT TASK

  Reveal Answer Answer: C Next Question

• Question 5

  

  How do you handle missing or corrupted data in a dataset?

  • Drop missing rows or columns
  • Replace missing values with mean/median/mode
  • Assign a unique category to missing values
  • All of the above

  Reveal Answer Answer: D Next Question

• Question 6

  

  Which one is incorrect understanding about Providers of Direct share?

  • A data provider is any Snowflake account that creates shares and makes them available to other Snowflake accounts to consume.
  • As a data provider, you share a database with one or more Snowflake accounts.
  • You can create as many shares as you want, and add as many accounts to a share as you want.
  • If you want to provide a share to many accounts, you can do the same via Direct Share.

  Reveal Answer Answer: D Next Question

• Question 7

  

  In a simple linear regression model (One independent variable), If we change the input variable by 1 unit. How much output variable will change?

  • by 1
  • no change
  • by intercept
  • by its slope

  Reveal Answer Answer: D Next Question

• Question 8

  

  Consider a data frame df with 10 rows and index [ 'r1', 'r2', 'r3', 'row4', 'row5', 'row6', 'r7', 'r8', 'r9', 'row10']. What does the aggregate method shown in below code do?g = df.groupby(df.index.str.len()) g.aggregate({'A':len, 'B':np.sum})

  • Computes Sum of column A values
  • Computes length of column A
  • Computes length of column A and Sum of Column B values of each group
  • Computes length of column A and Sum of Column B values

  Reveal Answer Answer: C Next Question

• Question 9

  

  Skewness of Normal distribution is

  • Negative
  • Positive
  • Undefined

  Reveal Answer Answer: C Next Question

• Question 10

  

  Mark the incorrect statement regarding Python UDF?

  • Python UDFs can contain both new code and calls to existing packages
  • For each row passed to a UDF, the UDF returns either a scalar (i.e. single) value or, if defined as a table function, a set of rows.
  • A UDF also gives you a way to encapsulate functionality so that you can call it repeatedly from multiple places in code
  • A scalar function (UDF) returns a tabular value for each input row

  Reveal Answer Answer: D Next Question

Page: 1 / 13
Total Questions: 65

Previous Page Next Page