A JSON object is loaded into a column named data using a Snowflake variant datatype. The root node of the object is BIKE. The child attribute for this root node is BIKEID.
Which statement will allow the user to access BIKEID?

• A.select data:BIKEID
• B.select data.BIKE.BIKEID
• C.select data:BIKE.BIKEID
• D.select data:BIKE:BIKEID

Comment: *

Name: *

Email: *

Verification: *

When working with table MY_TABLE that contains 10 rows, which sampling query will always return exactly 5 rows?

• A.SELECT * FROM MY_TABLE SAMPLE SYSTEM (5);
• B.SELECT * FROM MY_TABLE SAMPLE BERNOULLI (5);
• C.SELECT * FROM MY_TABLE SAMPLE (5 ROWS);
• D.SELECT * FROM MY_TABLE SAMPLE SYSTEM (1) SEED (5);

Comment: *

Name: *

Email: *

Verification: *

What should be considered when deciding to use a secure view? (Select TWO).

• A.No details of the query execution plan will be available in the query profiler.
• B.Once created there is no way to determine if a view is secure or not.
• C.Secure views do not take advantage of the same internal optimizations as standard views.
• D.It is not possible to create secure materialized views.
• E.The view definition of a secure view is still visible to users by way of the information schema.

Comment: *

Name: *

Email: *

Verification: *

What activities can a user with the ORGADMIN role perform? (Select TWO).

• A.Create information_schema in a database
• B.View usage information for all accounts in the organization.
• C.Enable database cloning for an account in the organization.
• D.Enable database replication for an account in the organization.
• E.View micro-partition information for all accounts in the organization.

Comment: *

Name: *

Email: *

Verification: *

Which items are considered schema objects in Snowflake? (Select TWO).

• A.Pipe
• B.File format
• C.Resource monitor
• D.Storage integration
• E.Virtual warehouse

Comment: *

Name: *

Email: *

Verification: *