COF-R02 무료 덤프문제 온라인 액세스

How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

• A.The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.
• B.The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.
• C.The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.
• D.The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

Which of the following statement is true of Snowflake?
Select one.

• A.It was built specifically for the cloud
• B.It was built for Hadoop architecture
• C.It's based on an Oracle Architecture
• D.It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
• E.it was built as an on-premises solution and then potted to the cloud

Which of the following DML commands isn't supported by Snowflake?

• A.TRUNCATE TABLE
• B.MERGE
• C.UPDATE
• D.UPSERT

Where is Snowflake metadata stored?

• A.In the remote storage layer
• B.Within the data files
• C.In the cloud services layer
• D.In the virtual warehouse layer

What is the default character set used when loading CSV files into Snowflake?

• A.UTF-16
• B.ANSI_X3.A
• C.ISO S859-1
• D.UTF-8