Which statement is not true about shared database?

• A.Shared databases can be re-shared with other accounts
• B.Shared databases cannot be cloned
• C.Time travel is not supported on a shared database
• D.Shared databases are read only

Comment: *

Name: *

Email: *

Verification: *

Search optimization does not support Materialized views and External Tables

• A.FALSE
• B.TRUE

Comment: *

Name: *

Email: *

Verification: *

Let's say that you have two JSONs as below
1. {"stuId":2000, "stuName":"Amy"}
2. {"stuId":2000,"stuCourse":"Snowflake"}
How will you write a query that will check if stuId in JSON in #1 is also there in JSON in#2

• A.with stu_demography as (select parse_json(column1) as src, src:stuId as ID from values('{"stuId":2000, "stuName":"Amy"}')),
• B.stu_course as (select parse_json(column1) as src, src:stuId as ID from values('{"stuId":2000,"stuCourse":"Snowflake"}')) select case when stdemo.ID in(select ID from stu_course) then 'True' else 'False' end as result from stu_demography stdemo;
• C.with stu_demography as (select parse_json(column1) as src, src['stuId'] as ID from values('{"stuId":2000, "stuName":"Amy"}')), stu_course as (select parse_json(column1) as src, src['stuId'] as ID from values('{"stuId":2000,"stuCourse":"Snowflake"}')) select case when stdemo.ID in(select ID from stu_course) then 'True' else 'False' end as result from stu_demography stdemo;
• D.with stu_demography as (select parse_json(column1) as src, src['STUID'] as ID from values('{"stuId":2000, "stuName":"Amy"}')), stu_course as (select parse_json(column1) as src, src['stuId'] as ID from values('{"stuId":2000,"stuCourse":"Snowflake"}')) select case when stdemo.ID in(select ID from stu_course) then 'True' else 'False' end as result from stu_demography stdemo;
• E.SELECT CONTAINS('{"stuId":2000, "stuName":"Amy"}','{"stuId":2000,"stuCourse":"Snowflake"}');

Comment: *

Name: *

Email: *

Verification: *

How do you validate the data that is unloaded using COPY INTO command

• A.After unloading, load the data into a relational table and validate the rows
• B.Use validation_mode='RETURN_ROWS'; with COPY command
• C.Load the data into a CSV file to validate the rows

Comment: *

Name: *

Email: *

Verification: *

This privilege applies to only shared databases. It grants ability to enable roles other than the owning role to access a shared database.
Which is that role?

• A.SHARED PRIVILEGES
• B.IMPORT SHARE
• C.IMPORTED PRIVILEGES

Comment: *

Name: *

Email: *

Verification: *