ADA-C01 무료 덤프문제 온라인 액세스

What are characteristics of Dynamic Data Masking? (Select TWO).

• A.A masking policy can be applied to the VALUE column of an external table.
• B.A masking policy that is currently set on a table can be dropped.
• C.The role that creates the masking policy will always see unmasked data in query results.
• D.A single masking policy can be applied to columns in different tables.
• E.A single masking policy can be applied to columns with different data types.

A Snowflake user runs a complex SQL query on a dedicated virtual warehouse that reads a large amount of data from micro-partitions. The same user wants to run another query that uses the same data set.
Which action would provide optimal performance for the second SQL query?

• A.Use the RESULT_SCAN function to post-process the output of the first query.
• B.Prevent the virtual warehouse from suspending between the running of the first and second queries.
• C.Assign additional clusters to the virtual warehouse.
• D.Increase the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session.

A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) that has been clustered by the STORE_ID column (varchar(50)). The vast majority of analyses on this table are grouped by STORE_ID to look at store performance.
There are 1000 stores operated by the retailer but most sales come from only 20 stores. The Administrator notes that most queries are currently experiencing poor pruning, with large amounts of bytes processed by even simple queries.
Why is this occurring?

• A.The table is not big enough to take advantage of the clustering key.
• B.Sales across stores are not uniformly distributed.
• C.The STORE_ID should be numeric.
• D.The cardinality of the stores to transaction count ratio is too low to use the STORE_ID as a clustering key.

An Administrator has a user who needs to be able to suspend and resume a task based on the current virtual warehouse load, but this user should not be able to modify the task or start a new run.
What privileges should be granted to the user to meet these requirements? (Select TWO).

• A.OWNERSHIP on the database and schema containing the task
• B.OPERATE on the task
• C.OWNERSHIP on the task
• D.USAGE on the database and schema containing the task
• E.EXECUTE TASK on the task

A team of developers created a new schema for a new project. The developers are assigned the role DEV_TEAM which was set up using the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE DEV TEAM;
GRANT USAGE, CREATE SCHEMA ON DATABASE DEV_DB01 TO ROLE DEV_TEAM;
GRANT USAGE ON WAREHOUSE DEV_WH TO ROLE DEV_TEAM;
Each team member's access is set up using the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE JDOE_PROFILE;
CREATE USER JDOE LOGIN NAME = 'JDOE' DEFAULT_ROLE='JDOE_PROFILE';
GRANT ROLE JDOE_PROFILE TO USER JDOE;
GRANT ROLE DEV_TEAM TO ROLE JDOE_PROFILE;
New tables created by any of the developers are not accessible by the team as a whole.
How can an Administrator address this problem?

• A.Set up future grants on the newly-created schemas.
• B.Assign usage privilege on the virtual warehouse DEV_WH to the role JDOE_PROFILE.
• C.Set up the new schema as a managed-access schema.
• D.Assign ownership privilege to DEV_TEAM on the newly-created schema.