What causes objects in a data share to become unavailable to a consumer account?

• A.The DATA_RETENTI0N_TIME_IN_DAYS parameter in the consumer account is set to 0.
• B.The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every
  24 hours.
• C.The objects in the data share are being deleted and the grant pattern is not re-applied systematically.
• D.The consumer account acquires the data share through a private data exchange.

Comment: *

Name: *

Email: *

Verification: *

What privilege should a user be granted to change permissions for new objects in a managed access schema?

• A.Grant the OWNERSHIP privilege on the schema.
• B.Grant the OWNERSHIP privilege on the database.
• C.Grant the MANAGE GRANTS global privilege.
• D.Grant ALL privileges on the schema.

Comment: *

Name: *

Email: *

Verification: *

What privilege is required to view the load statistics on a virtual warehouse?

• A.OPERATE
• B.USAGE
• C.MONITOR
• D.MODIFY

Comment: *

Name: *

Email: *

Verification: *

A reporting dashboard uses a dedicated warehouse that automatically suspends after five minutes of inactivity. Similar queries run sporadically, with gaps exceeding five minutes. Users notice that the first query after suspension takes significantly longer than subsequent queries while the warehouse remains active.
How should query performance be improved?

• A.Set MIN_CLUSTER_COUNT equal to MAX_CLUSTER_COUNT.
• B.Increase the warehouse size to X-Large.
• C.Use ALTER WAREHOUSE to increase STATEMENT_TIMEOUT_IN_SECONDS.
• D.Increase the AUTO_SUSPEND setting.

Comment: *

Name: *

Email: *

Verification: *

A global company needs to share financial reports with managers who are in different regions. Managers should only see the data from their respective regions. How can these requirements be met with the least amount of operational overhead?

• A.Create unique views for each region.
• B.Build individual reports for each manager.
• C.Use row-level security on the source data table used to generate the reports.
• D.Apply Dynamic Data Masking based on a custom role assigned to each manager.

Comment: *

Name: *

Email: *

Verification: *