Question 1

Which ones are the known limitations of using External function?

Options :

A :

Currently, external functions cannot be shared with data consumers via Secure Data Sharing.

B :

Currently, external functions must be scalar functions. A scalar external function re-turns a single value for each input row.

C :

External functions have more overhead than internal functions (both built-in functions and internal UDFs) and usually execute more slowly

D :

An external function accessed through an AWS API Gateway private endpoint can be accessed only from a Snowflake VPC (Virtual Private Cloud) on AWS and in the same AWS region.

Answer: A,B,C,D

Question 2

Data providers add Snowflake objects (databases, schemas, tables, secure views, etc.) to a share us-ing Which of the following options?

Options :

A : Grant privileges on objects to a share via Account role.

B : Grant privileges on objects directly to a share.

C : Grant privileges on objects to a share via a database role.

D : Grant privileges on objects to a share via a third-party role.

Answer: B,C

Question 3

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

Options :

A : Imputation

B : Binning

C : One hot encoding

D : Statistical

Answer: D

Question 4

Which one is the incorrect option to share data in Snowflake?

Options :

A : a Listing, in which you offer a share and additional metadata as a data product to one or more accounts.

B :

a Direct Marketplace, in which you directly share specific database objects (a share) to another account in your region using Snowflake Marketplace.

C :

a Direct Share, in which you directly share specific database objects (a share) to anoth-er account in your region.

D : a Data Exchange, in which you set up and manage a group of accounts and offer a share to that group.

Answer: B

Question 5

Which one is incorrect understanding about Providers of Direct share?

Options :

A :

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

B : As a data provider, you share a database with one or more Snowflake accounts.

C : You can create as many shares as you want, and add as many accounts to a share as you want.

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

Answer: D

Smartly Prepare Exam with Free Online SnowPro-Advanced-Data-Scientist Practice Test

Buying Options: