NEW QUESTION 88
What Snowflake features should be leveraged when modeling using Data Vault?

NEW QUESTION 89
When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?

NEW QUESTION 90
In a managed access schema, what are characteristics of the roles that can manage object privileges? (Select TWO).

NEW QUESTION 91
How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)

NEW QUESTION 92
A healthcare company is deploying a Snowflake account that may include Personal Health Information (PHI).
The company must ensure compliance with all relevant privacy standards.
Which best practice recommendations will meet data protection and compliance requirements? (Choose three.)

NEW QUESTION 93
A company wants to deploy its Snowflake accounts inside its corporate network with no visibility on the internet. The company is using a VPN infrastructure and Virtual Desktop Infrastructure (VDI) for its Snowflake users. The company also wants to re-use the login credentials set up for the VDI to eliminate redundancy when managing logins.
What Snowflake functionality should be used to meet these requirements? (Choose two.)

NEW QUESTION 94
A company’s Architect needs to find an efficient way to get data from an external partner, who is also a Snowflake user. The current solution is based on daily JSON extracts that are placed on an FTP server and uploaded to Snowflake manually. The files are changed several times each month, and the ingestion process needs to be adapted to accommodate these changes.
What would be the MOST efficient solution?

NEW QUESTION 95
What considerations need to be taken when using database cloning as a tool for data lifecycle management in a development environment? (Select TWO).

NEW QUESTION 96
There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permissions on the objects in these databases to perform their jobs. Accountants need read-write access to fin_db but only require read-only access to hr_db because the database is maintained by human resources personnel.
An Architect needs to create a read-only role for certain employees working in the human resources department.
Which permission sets must be granted to this role?

NEW QUESTION 97
An Architect would like to save quarter-end financial results for the previous six years.
Which Snowflake feature can the Architect use to accomplish this?

NEW QUESTION 98
Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)

NEW QUESTION 99
A Snowflake Architect is designing a multiple-account design strategy.
This strategy will be MOST cost-effective with which scenarios? (Select TWO).

NEW QUESTION 100
A Snowflake Architect is setting up database replication to support a disaster recovery plan. The primary database has external tables.
How should the database be replicated?

NEW QUESTION 101
Create a task and a stream following the below steps. So, when the
system$stream_has_data(‘rawstream1’) condition returns false, what will happen to the task ?
— Create a landing table to store raw JSON data.
— Snowpipe could load data into this table. create or replace table raw (var variant);
— Create a stream to capture inserts to the landing table.
— A task will consume a set of columns from this stream. create or replace stream rawstream1 on table raw;
— Create a second stream to capture inserts to the landing table.
— A second task will consume another set of columns from this stream. create or replace stream rawstream2 on table raw;
— Create a table that stores the names of office visitors identified in the raw data. create or replace table names (id int, first_name string, last_name string);
— Create a table that stores the visitation dates of office visitors identified in the raw data.
create or replace table visits (id int, dt date);
— Create a task that inserts new name records from the rawstream1 stream into the names table
— every minute when the stream contains records.
— Replace the ‘etl_wh’ warehouse with a warehouse that your role has USAGE privilege on. create or replace task raw_to_names
warehouse = etl_wh schedule = ‘1 minute’ when
system$stream_has_data(‘rawstream1’) as
merge into names n
using (select var:id id, var:fname fname, var:lname lname from rawstream1) r1 on n.id = to_number(r1.id)
when matched then update set n.first_name = r1.fname, n.last_name = r1.lname
when not matched then insert (id, first_name, last_name) values (r1.id, r1.fname, r1.lname)
;
— Create another task that merges visitation records from the rawstream1 stream into the visits table
— every minute when the stream contains records.
— Records with new IDs are inserted into the visits table;
— Records with IDs that exist in the visits table update the DT column in the table.
— Replace the ‘etl_wh’ warehouse with a warehouse that your role has USAGE privilege on. create or replace task raw_to_visits
warehouse = etl_wh schedule = ‘1 minute’ when
system$stream_has_data(‘rawstream2’) as
merge into visits v
using (select var:id id, var:visit_dt visit_dt from rawstream2) r2 on v.id = to_number(r2.id) when matched then update set v.dt = r2.visit_dt
when not matched then insert (id, dt) values (r2.id, r2.visit_dt)
;
— Resume both tasks.
alter task raw_to_names resume;
alter task raw_to_visits resume;
— Insert a set of records into the landing table. insert into raw
select parse_json(column1) from values
(‘{“id”: “123”,”fname”: “Jane”,”lname”: “Smith”,”visit_dt”: “2019-09-17”}’),
(‘{“id”: “456”,”fname”: “Peter”,”lname”: “Williams”,”visit_dt”: “2019-09-17”}’);
— Query the change data capture record in the table streams select * from rawstream1;
select * from rawstream2;

NEW QUESTION 102
Which semi-structured data function returns an OBJECT constructed from the arguments.

NEW QUESTION 103
Consider the following COPY command which is loading data with CSV format into a Snowflake table from an internal stage through a data transformation query.

This command results in the following error:
SQL compilation error: invalid parameter ‘validation_mode’
Assuming the syntax is correct, what is the cause of this error?

NEW QUESTION 104
What step will im the performance of queries executed against an external table?

NEW QUESTION 105
Consider the following scenario where a masking policy is applied on the CREDICARDND column of the CREDITCARDINFO table. The masking policy definition Is as follows:

Sample data for the CREDITCARDINFO table is as follows:
NAME EXPIRYDATE CREDITCARDNO
JOHN DOE 2022-07-23 4321 5678 9012 1234
if the Snowflake system rotes have not been granted any additional roles, what will be the result?

NEW QUESTION 106
What is a key consideration when setting up search optimization service for a table?

NEW QUESTION 107
What transformations are supported in the below SQL statement? (Select THREE).
CREATE PIPE … AS COPY … FROM (…)

NEW QUESTION 108
A Snowflake Architect created a new data share and would like to verify that only specific records in secure views are visible within the data share by the consumers.
What is the recommended way to validate data accessibility by the consumers?

NEW QUESTION 109
A company has a source system that provides JSON records for various loT operations. The JSON Is loading directly into a persistent table with a variant field. The data Is quickly growing to 100s of millions of records and performance to becoming an issue. There is a generic access pattern that Is used to filter on the create_date key within the variant field.
What can be done to improve performance?

NEW QUESTION 110
Which Snowflake data modeling approach is designed for BI queries?