Snowflake DSA-C02 Quiz 1 Topic 1 Questions 1-5

Question: 1

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.

Show Answer

Question: 2

Which type of Machine learning Data Scientist generally used for solving classification and regression problems?

ASupervised

BUnsupervised

CReinforcement Learning

CInstructor Learning

DRegression Learning

Show Answer

Question: 3

What is the risk with tuning hyper-parameters using a test dataset?

AModel will overfit the test set

BModel will underfit the test set

CModel will overfit the training set

DModel will perform balanced

Show Answer

Question: 4

Which type of Python UDFs let you define Python functions that receive batches of input rows as Pandas DataFrames and return batches of results as Pandas arrays or Series?

AMPP Python UDFs

BScaler Python UDFs

CVectorized Python UDFs

DHybrid Python UDFs

Show Answer

Question: 5

Which of the following cross validation versions is suitable quicker cross-validation for very large datasets with hundreds of thousands of samples?

Ak-fold cross-validation

BLeave-one-out cross-validation

CHoldout method

DAll of the above

Show Answer

Snowflake DSA-C02 Quiz:1 Topic:1 Questions:1-5