Prepare DSA-C02 Exam with Using DSA-C02 Dump Questions

If you are serious about passing your Snowflake DSA-C02 certification exam, practicing with DSA-C02 dumps questions is an essential step in your preparation process. These DSA-C02 dumps will help you assess your knowledge, identify your strengths and weaknesses, and improve your chances of passing the exam on the first try. So why wait? Start practicing today and give yourself the best possible chance of success! Test free DSA-C02 exam dumps questions below.

Page 1 of 2

1. Data Scientist used streams in ELT (extract, load, transform) processes where new data inserted in-to a staging table is tracked by a stream. A set of SQL statements transform and insert the stream contents into a set of production tables. Raw data is coming in the JSON format, but for analysis he needs to transform it into relational columns in the production tables.

Which of the following Data transformation SQL function he can used to achieve the same?

He could not apply Transformation on Stream table data.

lateral flatten()

METADATA$ACTION ()

Transpose()

 Loading...

2. The most widely used metrics and tools to assess a classification model are:

Confusion matrix

Cost-sensitive accuracy

Area under the ROC curve

All of the above

 Loading...

3. Which of the following Functions do Support Windowing?

HASH_AGG

ENCRYPT

EXTRACT

LISTAGG

 Loading...

4. Select the correct mappings:

I. W Weights or Coefficients of independent variables in the Linear regression model --> Model Parameter

II. K in the K-Nearest Neighbour algorithm --> Model Hyperparameter

III. Learning rate for training a neural network --> Model Hyperparameter

IV. Batch Size --> Model Parameter

I,II

I,II,III

III,IV

II,III,IV

 Loading...

5. Which ones are the type of visualization used for Data exploration in Data Science?

Heat Maps

Newton AI

Feature Distribution by Class

2D-Density Plots

Sand Visualization

 Loading...

6. 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

 Loading...

7. 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

 Loading...

8. SHOW GRANTS OF SHARE product_s;

GRANT USAGE ON DATABASE product_db TO SHARE product_s;

CREATE DIRECT SHARE product_s;

GRANT SELECT ON TABLE sales_db. product_agg.Item_agg TO SHARE product_s;

ALTER SHARE product_s ADD ACCOUNTS=xy12345, yz23456;

 Loading...

9. Which method is used for detecting data outliers in Machine learning?

Scaler

Z-Score

BOXI

CMIYC

 Loading...

10. Which metric is not used for evaluating classification models?

Recall

Accuracy

Mean absolute error

Precision

 Loading...

Page 2 of 2

11. All aggregate functions except _____ ignore null values in their input collection

Count(attribute)

Count(*)

Avg

Sum

 Loading...

12. Which of the following is a Python-based web application framework for visualizing data and analyzing results in a more efficient and flexible way?

StreamBI

Streamlit

Streamsets

Rapter

 Loading...

13. Select the Data Science Tools which are known to provide native connectivity to Snowflake?

Denodo

DvSUM

DiYotta

HEX

 Loading...

14. Consider a data frame df with 10 rows and index [ 'r1', 'r2', 'r3', 'row4', 'row5', 'row6', 'r7', 'r8', 'r9', 'row10'].

What does the expression g = df.groupby(df.index.str.len()) do?

Groups df based on index values

Groups df based on length of each index value

Groups df based on index strings

Data frames cannot be grouped by index values. Hence it results in Error.

 Loading...

15. Mark the Incorrect statements regarding MIN / MAX Functions?

NULL values are skipped unless all the records are NULL

NULL values are ignored unless all the records are NULL, in which case a NULL value is returned

The data type of the returned value is the same as the data type of the input values

For compatibility with other systems, the DISTINCT keyword can be specified as an argument for MIN or MAX, but it does not have any effect

 Loading...

16. Which of the following is a useful tool for gaining insights into the relationship between features and predictions?

numpy plots

sklearn plots

Partial dependence plots (PDP)

FULL dependence plots (FDP)

 Loading...

17. Which one is not the feature engineering techniques used in ML data science world?

Imputation

Binning

One hot encoding

Statistical

 Loading...

18. Secure Data Sharing do not let you share which of the following selected objects in a database in your account with other Snowflake accounts?

Sequences

Tables

External tables

Secure UDFs

 Loading...

19. To return the contents of a DataFrame as a Pandas DataFrame, Which of the following method can be used in SnowPark API?

REPLACE_TO_PANDAS

SNOWPARK_TO_PANDAS

CONVERT_TO_PANDAS

TO_PANDAS

 Loading...

20. Mark the Incorrect understanding of Data Scientist about Streams?

Streams on views support both local views and views shared using Snowflake Secure Data Sharing, including secure views.

Streams can track changes in materialized views.

Streams itself does not contain any table data.

Streams do not support repeatable read isolation.

 Loading...

 Loading...