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

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

Add to Whishlist

List of questions

Question 21

Report Export Collapse

Mark the Incorrect understanding of Data Scientist about Streams?

Become a Premium Member for full access
  Unlock Premium Member

Question 22

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 23

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 24

Report Export Collapse

Which of the following Snowflake parameter can be used to Automatically Suspend Tasks which are running Data science pipelines after specified Failed Runs?

Become a Premium Member for full access
  Unlock Premium Member

Question 25

Report Export Collapse

Mark the incorrect statement regarding Python UDF?

Become a Premium Member for full access
  Unlock Premium Member

Question 26

Report Export Collapse

Data Scientist can query, process, and transform data in a which of the following ways using Snowpark Python. [Select 2]

Become a Premium Member for full access
  Unlock Premium Member

Question 27

Report Export Collapse

Which Python method can be used to Remove duplicates by Data scientist?

Become a Premium Member for full access
  Unlock Premium Member

Question 28

Report Export Collapse

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})

Become a Premium Member for full access
  Unlock Premium Member

Question 29

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 30

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member
Total 65 questions
Go to page: of 7
Search