2024 itPass4sure Snowflake DEA-C01 Dumps and Exam Test Engine
Snowflake DEA-C01 DUMPS WITH REAL EXAM QUESTIONS
NEW QUESTION # 32
A company is building a dashboard for thousands of Analysts. The dashboard presents the results of a few summary queries on tables that are regularly updated. The query conditions vary by tope according to what data each Analyst needs Responsiveness of the dashboard queries is a top priority, and the data cache should be preserved.
How should the Data Engineer configure the compute resources to support this dashboard?
- A. Create a virtual warehouse for every 250 Analysts Monitor to determine how many of these virtual warehouses are being utilized at capacity.
- B. Assign queries to a multi-cluster virtual warehouse with economy auto-scaling Allow the system to automatically start and stop clusters according to demand.
- C. Create a size XL virtual warehouse to support all the dashboard queries Monitor query runtimes to determine whether the virtual warehouse should be resized.
- D. Assign all queries to a multi-cluster virtual warehouse set to maximized mode Monitor to determine the smallest suitable number of clusters.
Answer: D
Explanation:
Explanation
This option is the best way to configure the compute resources to support this dashboard. By assigning all queries to a multi-cluster virtual warehouse set to maximized mode, the Data Engineer can ensure that there is enough compute capacity to handle thousands of concurrent queries from different analysts. A multi-cluster virtual warehouse can scale up or down by adding or removing clusters based on the load. A maximized scaling policy ensures that there is always at least one cluster running and that new clusters are added as soon as possible whenneeded. By monitoring the utilization and performance of the virtual warehouse, the Data Engineer can determine the smallest suitable number of clusters that can meet the responsiveness requirement and minimize costs.
NEW QUESTION # 33
Select the Correct statements with regard to using Federated authentication/SSO?
- A. Snowflake supports using SSO with organizations, and you can use the corresponding URL in the SAML2 security integration.
- B. Snowflake supports using MFA in conjunction with SSO to provide additional levels of security.
- C. Snowflake supports multiple audience values (i.e. Audience or Audience Restriction Fields) in the SAML 2.0 assertion from the identity provider to Snowflake.
- D. Snowflake supports SSO with Private Connectivity to the Snowflake Service for Snow-flake accounts on Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform.
Answer: A,B,C,D
NEW QUESTION # 34
A stream called TRANSACTIONS_STM is created on top of a transactions table in a continuous pipeline running in Snowflake. After a couple of months, the TRANSACTIONS table is renamed transactiok3_raw to comply with new naming standards What will happen to the TRANSACTIONS _STM object?
- A. Reading from the traksactioks_3T>: stream will succeed for some time after the expected STALE_TIME.
- B. TRANSACTIONS _STMwill be automatically renamedTRANSACTIONS _RAW_STM.
- C. TRANSACTIONS _STMwill keep working as expected
- D. TRANSACTIONS _STMwill be stale and will need to be re-created
Answer: D
Explanation:
Explanation
A stream is a Snowflake object that records the history of changes made to a table. A stream is associated with a specific table at the time of creation, and it cannot be altered to point to a different table later. Therefore, if the source table is renamed, the stream will become stale and will need to be re-created with the new table name. The other options are not correct because:
TRANSACTIONS _STM will not keep working as expected, as it will lose track of the changes made to the renamed table.
TRANSACTIONS _STM will not be automatically renamed TRANSACTIONS _RAW_STM, as streams do not inherit the name changes of their source tables.
Reading from the transactions_stm stream will not succeed for some time after the expected STALE_TIME, as streams do not have a STALE_TIME property.
NEW QUESTION # 35
When created, a stream logically takes an initial snapshot of every row in the source object and the contents of a stream change as DML statements execute on the source table.
A Data Engineer, Sophie Created a view that queries the table and returns the CURRENT_USER and CURRENT_TIMESTAMP values for the query transaction. A Stream has been created on views to capture CDC.
Tony, another user inserted the data e.g.
insert into <table> values (1),(2),(3);
Emily, another user also inserted the data e.g.
insert into <table> values (4),(5),(6);
What will happened when Different user queries the same stream after 1 hour?
- A. All the Six Records would be displayed with CURRENT_USER & CUR-RENT_TIMESTAMP while querying Streams.
- B. All the Six records would be displayed with User 'Sohpie' Who is the owner of the View.
- C. User would be displayed with the one who queried during the session, but Recorded timestamp would be of past 1 hour i.e. actual records insertion time.
- D. All the 6 records would be shown with METADATA$ACTION as 'INSERT' out of which 3 records would be displayed with username 'Tony' & rest 3 records would be displayed with username 'Emily'.
Answer: A
Explanation:
Explanation
When User queries the stream, the stream returns the username for the user. The stream also returns the current timestamp for the query transaction in each row, NOT the timestamp when each row was inserted.
NEW QUESTION # 36
A Data Engineer is working on a Snowflake deployment in AWS eu-west-1 (Ireland). The Engineer is planning to load data from staged files into target tables using the copy into command Which sources are valid? (Select THREE)
- A. External stage on GCP us-central1 (Iowa)
- B. Internal stage on GCP us-central1 (Iowa)
- C. Internal stage on AWS eu-central-1 (Frankfurt)
- D. External stage in an Amazon S3 bucket on AWS eu-central 1 (Frankfurt)
- E. SSO attached to an Amazon EC2 instance on AWS eu-west-1 (Ireland)
- F. External stage in an Amazon S3 bucket on AWS eu-west-1 (Ireland)
Answer: A,D,F
Explanation:
Explanation
The valid sources for loading data from staged files into target tables using the copy into command are:
External stage on GCP us-central1 (Iowa): This is a valid source because Snowflake supports cross-cloud data loading from external stages on different cloud platforms and regions than the Snowflake deployment.
External stage in an Amazon S3 bucket on AWS eu-west-1 (Ireland): This is a valid source because Snowflake supports data loading from external stages on the same cloud platform and region as the Snowflake deployment.
External stage in an Amazon S3 bucket on AWS eu-central 1 (Frankfurt): This is a valid source because Snowflake supports cross-region data loading from external stages on different regions than the Snowflake deployment within the same cloud platform. The invalid sources are:
Internal stage on GCP us-central1 (Iowa): This is an invalid source because internal stages are always located on the same cloud platform and region as the Snowflake deployment. Therefore, an internal stage on GCP us-central1 (Iowa) cannot be used for a Snowflake deployment on AWS eu-west-1 (Ireland).
Internal stage on AWS eu-central-1 (Frankfurt): This is an invalid source because internal stages are always located on the same region as the Snowflake deployment. Therefore, an internal stage on AWS eu-central-1 (Frankfurt) cannot be used for a Snowflake deployment on AWS eu-west-1 (Ireland).
SSO attached to an Amazon EC2 instance on AWS eu-west-1 (Ireland): This is an invalid source because SSO stands for Single Sign-On, which is a security integration feature in Snowflake, not a data staging option.
NEW QUESTION # 37
Data Engineer Loading File named snowdata.tsv in the /datadir directory from his local machine to Snowflake stage and try to prefix the file with a folder named tablestage, please mark the correct command which helps him to load the files data into snowflake internal Table stage?
- A. put file:///datadir/snowdata.tsv @%tablestage;
- B. put file://c:\datadir\snowdata.tsv @~/tablestage;
- C. put file://c:\datadir\snowdata.tsv @tablestage;
- D. put file://c:\datadir\snowdata.tsv @%tablestage;
Answer: D
Explanation:
Explanation
Execute PUT to upload (stage) local data files into an internal stage.
@% character combination identifies a table stage.
NEW QUESTION # 38
Data engineer designed the data pipelines using Snowpipe to load data files into Snowflake tables, what will happen in case few files with same name but modified data are queued for reloading?
- A. Snowpipe uses file loading metadata associated with each table object, so no metadata available to prevent duplication.
- B. eTAG is changed for Files even they are having same name, so data will be duplicated in SnowFlake tables.
- C. Snowpipe uses file loading metadata associated with each pipe object to prevent reload-ing the same files (and duplicating data) in a table.
- D. Data will be reloaded as files are modified & its associated metadata also changed. But Snowflake handle implicitly deduplication.
Answer: C
Explanation:
Explanation
Snowflake uses file loading metadata to prevent reloading the same files (and duplicating data) in a table.
Snowpipe prevents loading files with the same name even if they were later modified (i.e. have a different eTag).
The file loading metadata is associated with the pipe object rather than the table. As a result:
Staged files with the same name as files that were already loaded are ignored, even if they have been modified, e.g. if new rows were added or errors in the file were corrected.
Truncating the table using the TRUNCATE TABLE command does not delete the Snowpipe file loading metadata.
NEW QUESTION # 39
Which privilege are required on an object (i.e. user or role) with USERADMIN Role can modify the object properties?
- A. OPEARTE
- B. OWNERSHIP
- C. MANAGE GRANTS
- D. MODIFY
Answer: B
NEW QUESTION # 40
Which system role is recommended for a custom role hierarchy to be ultimately assigned to?
- A. SECURITYADMIN
- B. SYSTEMADMIN
- C. USERADMIN
- D. ACCOUNTADMIN
Answer: A
Explanation:
Explanation
The system role that is recommended for a custom role hierarchy to be ultimately assigned to is SECURITYADMIN. This role has the manage grants privilege on all objects in an account, which allows it to grant access privileges to other roles or revoke them as needed. This role can also create or modify custom roles and assign them to users or other roles. By assigning custom roles to SECURITYADMIN, the role hierarchy can be managed centrally and securely. The other options are not recommended system roles for a custom role hierarchy to be ultimately assigned to. Option A is incorrect because ACCOUNTADMIN is the most powerful role in an account, which has full access to all objects and operations. Assigning custom roles to ACCOUNTADMIN can pose a security risk and should be avoided. Option C is incorrect because SYSTEMADMIN is a role that has full access to all objects in the public schema of the account, but not to other schemas or databases. Assigning custom roles to SYSTEMADMIN can limit the scope and flexibility of the role hierarchy. Option D is incorrect because USERADMIN is a role that can manage users and roles in an account, but not grant access privileges to other objects. Assigning custom roles to USERADMIN can prevent the role hierarchy from controlling access to data and resources.
NEW QUESTION # 41
Data Engineer decided to call the public REST endpoints to load data and retrieve load history re-ports. Which of the following REST endpoints and a Snowflake Information Schema table function for viewing your load history can be used by her? [Select All that apply]
- A. Account Usage view:COPY_HISTORY
- B. Information Schema table function: LOAD_HISTORY
- C. Information Schema table function: COPY_HISTORY
- D. REST endpoints: insertReport or loadHistoryScan
- E. REST endpoints: loadinsertReport or HistoryScan
Answer: A,C,D
Explanation:
Explanation
Snowflake provides REST endpoints and an Snowflake Information Schema table function for viewing your load history:
REST endpoints:
insertReport
loadHistoryScan
Information Schema table function:
COPY_HISTORY
Account Usage view:
COPY_HISTORY
NEW QUESTION # 42
Which Snowflake feature facilitates access to external API services such as geocoders. data transformation, machine Learning models and other custom code?
- A. External functions
- B. Java User-Defined Functions (UDFs)
- C. Security integration
- D. External tables
Answer: A
Explanation:
Explanation
External functions are Snowflake functions that facilitate access to external API services such as geocoders, data transformation, machine learning models and other custom code. External functions allow users to invoke external services from within SQL queries and pass arguments and receive results as JSON values. External functions require creating an API integration object and an external function object in Snowflake, as well as deploying an external service endpoint that can communicate with Snowflake via HTTPS.
NEW QUESTION # 43
A Data Engineer has created table t1 with datatype VARIANT:
create or replace table t1 (cl variant);
The Engineer has loaded the following JSON data set. which has information about 4 laptop models into the table:
The Engineer now wants to query that data set so that results are shown as normal structured data. The result should be 4 rows and 4 columns without the double quotes surrounding the data elements in the JSON data.
The result should be similar to the use case where the data was selected from a normal relational table z2 where t2 has string data type columns model__id. model, manufacturer, and =iccisi_r.an=. and is queried with the SQL clause select * from t2; Which select command will produce the correct results?
- A.
- B.
- C.
- D.
Answer: B
NEW QUESTION # 44
While creating External function, Which Database object required with at least ACCOUNTAD-MIN privileges?
- A. None of the above required.
- B. API Integration
- C. STORAGE Integration
- D. SECURITY Integration
Answer: B
NEW QUESTION # 45
Which column provides information when the stream became stale or may become stale if not con-sumed?
- A. STALE_PERIOD_AFTER
- B. STALE_AFTER
- C. STREAM_STALE_PERIOD
- D. STALE_STREAM_PERIOD
Answer: B
Explanation:
Explanation
execute SHOW STREAMS command.
Column Name: STALE_AFTER
Timestamp when the stream became stale or may become stale if not consumed. The value is calcu-lated by adding the retention period for the source table (i.e. the larger of the DA-TA_RETENTION_TIME_IN_DAYS or MAX_DATA_EXTENSION_TIME_IN_DAYS parame-ter setting) to the last time the stream was read.
NEW QUESTION # 46
A Data Engineer defines the following masking policy:
....
must be applied to the full_name column in the customer table:
Which query will apply the masking policy on the full_name column?
- A. ALTER TABLE customer MODIFY COLUMN first_name ADD MASKING POLICY name_policy,
- B. ALTER TABLE customer MODIFY COLUMN full_name Set MASKING POLICY name_policy;
- C. ALTER TABLE customer MODIFY COLUMN full_nam ADD MASKING POLICY name_poiicy;
- D. ALTER TABLE customer MODIFY COLUMN first_nane SET MASKING POLICY name_policy; lasT_name SET MASKING POLICY name_pclicy;
Answer: B
Explanation:
Explanation
The query that will apply the masking policy on the full_name column is ALTER TABLE customer MODIFY COLUMN full_name SET MASKING POLICY name_policy;. This query will modify the full_name column and associate it with the name_policy masking policy, which will mask the first and last names of the customers with asterisks. The other options are incorrect because they do not follow the correct syntax for applying a masking policy on a column. Option B is incorrect because it uses ADD instead of SET, which is not a valid keyword for modifying a column. Option C is incorrect because it tries to apply the masking policy on two columns, first_name and last_name, which are not part of the table structure. Option D is incorrect because it uses commas instead of dots to separate the database, schema, and table names
NEW QUESTION # 47
Data Engineer looking out for quick tool for understanding the mechanics of queries & need to know more about the performance or behaviour of a particular query.
He should go to which feature of snowflake which can help him to spot typical mistakes in SQL query expressions to identify potential performance bottlenecks and improvement opportunities?
- A. Query Designer
- B. Query Optimizer
- C. Query Profile
- D. Performance Metadata table
Answer: C
Explanation:
Explanation
Query Profile, available through the classic web interface, provides execution details for a query. For the selected query, it provides a graphical representation of the main components of the pro-cessing plan for the query, with statistics for each component, along with details and statistics for the overall query.
Query Profile is a powerful tool for understanding the mechanics of queries. It can be used whenev-er you want or need to know more about the performance or behavior of a particular query. It is de-signed to help you spot typical mistakes in SQL query expressions to identify potential performance bottlenecks and improvement opportunities.
NEW QUESTION # 48
......
2024 New itPass4sure DEA-C01 PDF Recently Updated Questions: https://www.itpass4sure.com/DEA-C01-practice-exam.html
DEA-C01 Exam with Guarantee Updated 67 Questions: https://drive.google.com/open?id=1ZzDyotdwEmAzcK_X6de-6rCgMRZ4dQ2d
