Snowflake DSA-C02 Exam Practice Test Instant Access

Question 1

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?

AReturns the row name r3

BResults in Error

CReturns the third column

DFilters the row labelled r3

Answer : D

It will Filters the row labelled r3.

Question 2

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?

ATask

BDynamic tables

CStream

DTags

EDelta

FOFFSET

Answer : C

A stream 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. This process is referred to as change data capture (CDC). An individual table stream tracks the changes made to rows in a source table. A table stream (also referred to as simply a ''stream'') makes a ''change table'' available of what changed, at the row level, between two transactional points of time in a table. This allows querying and consuming a sequence of change records in a transactional fashion.

Streams can be created to query change data on the following objects:

* Standard tables, including shared tables.

* Views, including secure views

* Directory tables

* Event tables

Question 3

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

ASequences

BTables

CExternal tables

DSecure UDFs

Answer : A

Secure Data Sharing lets you share selected objects in a database in your account with other Snow-flake accounts. You can share the following Snowflake database objects:

Tables

External tables

Secure views

Secure materialized views

Secure UDFs

Snowflake enables the sharing of databases through shares, which are created by data providers and ''imported'' by data consumers.

Question 4

Skewness of Normal distribution is ___________

ANegative

BPositive

DUndefined

Answer : C

Since the normal curve is symmetric about its mean, its skewness is zero. This is a theoretical explanation for mathematical proofs, you can refer to books or websites that speak on the same in detail.

Question 5

Mark the incorrect statement regarding usage of Snowflake Stream & Tasks?

ASnowflake automatically resizes and scales the compute resources for serverless tasks.

BSnowflake ensures only one instance of a task with a schedule (i.e. a standalone task or the root task in a DAG) is executed at a given time. If a task is still running when the next scheduled execution time occurs, then that scheduled time is skipped.

CStreams support repeatable read isolation.

DAn standard-only stream tracks row inserts only.

Answer : D

All are correct except a standard-only stream tracks row inserts only.

A standard (i.e. delta) stream tracks all DML changes to the source object, including inserts, up-dates, and deletes (including table truncates).

Question 6

What is the formula for measuring skewness in a dataset?

AMEAN - MEDIAN

BMODE - MEDIAN

C(3(MEAN - MEDIAN))/ STANDARD DEVIATION

D(MEAN - MODE)/ STANDARD DEVIATION

Answer : C

Since the normal curve is symmetric about its mean, its skewness is zero. This is a theoretical expla-nation for mathematical proofs, you can refer to books or websites that speak on the same in detail.

Question 7

Which one is incorrect understanding about Providers of Direct share?

AA data provider is any Snowflake account that creates shares and makes them available to other Snowflake accounts to consume.

BAs a data provider, you share a database with one or more Snowflake accounts.

CYou can create as many shares as you want, and add as many accounts to a share as you want.

DIf you want to provide a share to many accounts, you can do the same via Direct Share.

Answer : D

If you want to provide a share to many accounts, you might want to use a listing or a data ex-change.

Snowflake SnowPro Advanced: Data Scientist Certification DSA-C02 Exam Practice Test