ExamGecko
Login
Home / Snowflake / DSA-C02 / List of questions
Ask Question

Snowflake DSA-C02 Practice Test - Questions Answers, Page 4

Add to Whishlist

List of questions

Question 31

Report Export Collapse

Which command is used to install Jupyter Notebook?

Become a Premium Member for full access
  Unlock Premium Member

Question 32

Report Export Collapse

Which of the following process best covers all of the following characteristics?

* Collecting descriptive statistics like min, max, count and sum.

* Collecting data types, length and recurring patterns.

* Tagging data with keywords, descriptions or categories.

* Performing data quality assessment, risk of performing joins on the data.

* Discovering metadata and assessing its accuracy.

Identifying distributions, key candidates, foreign-key candidates, functional dependencies, embedded value dependencies, and performing inter-table analysis.

Become a Premium Member for full access
  Unlock Premium Member

Question 33

Report Export Collapse

Which of the Following is not type of Windows function in Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 34

Report Export Collapse

Which of the following Functions do Support Windowing?

Become a Premium Member for full access
  Unlock Premium Member

Question 35

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 36

Report Export Collapse

Mark the Incorrect statements regarding MIN / MAX Functions?

Become a Premium Member for full access
  Unlock Premium Member

Question 37

Report Export Collapse

Which one is not the types of Feature Engineering Transformation?

Become a Premium Member for full access
  Unlock Premium Member

Question 38

Report Export Collapse

Which one is not Types of Feature Scaling?

Become a Premium Member for full access
  Unlock Premium Member

Question 39

Report Export Collapse

Select the Correct Statements regarding Normalization?

Become a Premium Member for full access
  Unlock Premium Member

Question 40

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member
Total 65 questions
Go to page: of 7
Open VPLUS File
Convert VPLUS to PDF

Related questions

Mark the incorrect statement regarding usage of Snowflake Stream & Tasks?
Consider a data frame df with columns ['A', 'B', 'C', 'D'] and rows ['r1', 'r2', 'r3']. What does the ex-pression df[lambda x : x.index.str.endswith('3')] do?
Which method is used for detecting data outliers in Machine learning?
Which Python method can be used to Remove duplicates by Data scientist?
Which one is not Types of Feature Scaling?
Which of the following metrics are used to evaluate classification models?
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})
Data Scientist can query, process, and transform data in a which of the following ways using Snowpark Python. [Select 2]
Mark the correct steps for saving the contents of a DataFrame to a Snowflake table as part of Moving Data from Spark to Snowflake?
Which one is not the types of Feature Engineering Transformation?