Regular Free Updates DEA-C01 Dumps Real Exam Questions Test Engine Nov 15, 2023
Practice Test Questions Verified Answers As Experienced in the Actual Test!
NEW QUESTION # 20
When using the CURRENT_ROLE and CURRENT_USER functions with secure views that will be shared to other Snowflake accounts, Snowflake returns a NULL value for these functions?
- A. FALSE
- B. TRUE
Answer: B
Explanation:
Explanation
When using the CURRENT_ROLE and CURRENT_USER functions with secure views that will be shared to other Snowflake accounts, Snowflake returns a NULL value for these functions. The reason is that the owner of the data being shared does not typically control the users or roles in the account with which the view is being shared.
NEW QUESTION # 21
Can Masking policies be applied to virtual columns?
- A. TRUE
- B. FALSE
Answer: B
NEW QUESTION # 22
What are Invalid rules applicable when using stored procedure contains transaction?
- A. All Rules are Applicable.
- B. You cannot start a transaction inside the stored procedure, then complete the transac-tion after returning from the procedure.
- C. You cannot start a transaction before calling the stored procedure, then complete the transaction inside the stored procedure.
- D. A transaction can be inside a stored procedure, or a stored procedure can be inside a transaction.
- E. If a transaction is started inside a stored procedure and is still active when the stored procedure finishes, then an error occurs, and the transaction is rolled back.
- F. A transaction inside a stored procedure can include a call to another stored procedure that contains a transaction.
Answer: A
NEW QUESTION # 23
Ryan, a Data Engineer, accidently drop the Share named SF_SHARE which results in immediate access revoke for all the consumers (i.e., accounts who have created a database from that SF_SHARE). What action he can take to recover the dropped Share?
- A. A dropped share cannot be restored. The share must be created again using the CRE-ATE SHARE command and then configured using GRANT <privilege> ... TO SHARE and ALTER SHARE.
- B. Consumer accounts that have created databases from the share will still be able to que-ry these databases as Share is separate securable object & it's still accessible using time travel feature.
- C. By Executing UNDROP command he could possibly recover the dropped Share SF_SHARE & its associated Databases for immediate consumer access.
- D. He can recreate a share with the same name as a previous share which does restore the databases created (by any consumers) from the share SF_SHARE.
Answer: A
Explanation:
Explanation
You can drop a share at any time using the DROP SHARE command.
Dropping a share instantly invalidates all databases created from the share by consumer accounts.
All queries and other operations performed on these databases will no longer work.
After dropping a share, you can recreate it with the same name;
however, this does not restore any of the databases created from the share by consumer accounts.
The recreated share is treated as a new share and all consumer accounts must create a new database from the new share.
NEW QUESTION # 24
As a Data Engineer, you have requirement to query most recent data from the Large Dataset that reside in the external cloud storage, how would you design your data pipelines keeping in mind fastest time to delivery?
- A. Unload data into SnowFlake Internal data storage using PUT command.
- B. External tables with Materialized views can be created in Snowflake.
- C. Snowpipe can be leveraged with streams to load data in micro batch fashion with CDC streams that capture most recent data only.
- D. Direct Querying External tables on top of existing data stored in external cloud storage for analysis without first loading it into Snowflake.
- E. Data pipelines would be created to first load data into internal stages & then into Per-manent table with SCD Type 2 transformation.
Answer: B
Explanation:
Explanation
In a typical table, the data is stored in the database; however, in an external table, the data is stored in files in an external stage. External tables store file-level metadata about the data files, such as the filename, a version identifier and related properties. This enables querying data stored in files in an external stage as if it were inside a database. External tables can access data stored in any format supported by COPY INTO <table> statements.
External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external ta-bles.
Querying data stored external to the database is likely to be slower than querying native database tables; however, materialized views based on external tables can improve query performance.
Creating External tables enable user for querying existing data stored in external cloud storage for analysis without first loading it into Snowflake. The source of truth for the data remains in the ex-ternal cloud storage.
Data sets materialized in Snowflake via materialized views are read-only.
This solution is especially beneficial to accounts that have a large amount of data stored in external cloud storage and only want to query a portion of the data; for example, the most recent data. Users can create materialized views on subsets of this data for improved query performance.
NEW QUESTION # 25
A large table with 200 columns contains two years of historical data. When queried. the table is filtered on a single day Below is the Query Profile:
Using a size 2XL virtual warehouse, this query look over an hour to complete What will improve the query performance the MOST?
- A. Implement the search optimization service on the table
- B. Increase the number of clusters in the virtual warehouse
- C. increase the size of the virtual warehouse.
- D. Add a date column as a cluster key on the table
Answer: D
Explanation:
Explanation
Adding a date column as a cluster key on the table will improve the query performance by reducing the number of micro-partitions that need to be scanned. Since the table is filtered on a single day, clustering by date will make the query more selective and efficient.
NEW QUESTION # 26
Which Function would Data engineer used to recursively resume all tasks in Chain of Tasks rather than resuming each task individually (using ALTER TASK ... RESUME)?
- A. SYSTEM$TASK_DEPENDENTS_ENABLE
- B. SYSTEM$TASK_DEPENDENTS_RESUME
- C. SYSTEM$TASK_DEPENDENTS
- D. SYSTEM$TASK_RECURSIVE_ENABLE
Answer: A
Explanation:
Explanation
To recursively resume all tasks in a DAG(A Directed Acyclic Graph (DAG) is a series of tasks com-posed of a single root task and additional tasks, organized by their dependencies.), query the SYS-TEM$TASK_DEPENDENTS_ENABLE function rather than resuming each task individually (us-ing ALTER TASK ... RESUME).
NEW QUESTION # 27
Company A and Company B both have Snowflake accounts. Company A's account is hosted on a different cloud provider and region than Company B's account Companies A and B are not in the same Snowflake organization.
How can Company A share data with Company B? (Select TWO).
- A. Create a share within Company A's account, and create a reader account that is a recipient of the share Grant Company B access to the reader account
- B. Create a separate database within Company A's account to contain only those data sets they wish to share with Company B Create a share within Company A's account and add all the objects within this separate database to the share Add Company B's account as a recipient of the share
- C. Create a share within Company A's account and add Company B's account as a recipient of that share
- D. Use database replication to replicate Company A's data into Company B's account Create a share within Company B's account and grant users within Company B's account access to the share
- E. Create a new account within Company A's organization in the same cloud provider and region as Company B's account Use database replication to replicate Company A's data to the new account Create a share within the new account and add Company B's account as a recipient of that share
Answer: B,C
Explanation:
Explanation
The ways that Company A can share data with Company B are:
Create a share within Company A's account and add Company B's account as a recipient of that share:
This is a valid way to share data between different accounts on different cloud platforms and regions.
Snowflake supports cross-cloud and cross-region data sharing, which allows users to create shares and grant access to other accounts regardless of their cloud platform or region. However, this option may incur additional costs for network transfer and storage replication.
Create a separate database within Company A's account to contain only those data sets they wish to share with Company B Create a share within Company A'saccount and add all the objects within this separate database to the share Add Company B's account as a recipient of the share: This is also a valid way to share data between different accounts on different cloud platforms and regions. This option is similar to the previous one, except that it uses a separate database to isolate the data sets that need to be shared. This can improve security and manageability of the shared data. The other options are not valid because:
Create a share within Company A's account, and create a reader account that is a recipient of the share Grant Company B access to the reader account: This option is not valid because reader accounts are not supported for cross-cloud or cross-region data sharing. Reader accounts are Snowflake accounts that can only consume data from shares created by their provider account. Reader accounts must be on the same cloud platform and region as their provider account.
Use database replication to replicate Company A's data into Company B's account Create a share within Company B's account and grant users within Company B's account access to the share: This option is not valid because database replication cannot be used for cross-cloud or cross-region data sharing.
Database replication is a feature in Snowflake that allows users to copy databases across accounts within the same cloud platform and region. Database replication cannot copy databases across different cloud platforms or regions.
Create a new account within Company A's organization in the same cloud provider and region as Company B's account Use database replication to replicate Company A's data to the new account Create a share within the new account and add Company B's account as a recipient of that share: This option is not valid because it involves creating a new account within Company A's organization, which may not be feasible or desirable for Company A. Moreover, this option is unnecessary, as Company A can directly share data with Company B without creating an intermediate account.
NEW QUESTION # 28
Mark the Correct Statements:
Statement 1. Snowflake's zero-copy cloning feature provides a convenient way to quickly take a "snapshot" of any table, schema, or database.
Statement 2. Data Engineer can use zero-copy cloning feature for creating instant backups that do not incur any additional costs (until changes are made to the cloned object).
- A. Both are False.
- B. Statement 2
- C. Statement 1
- D. Statement 1 & 2 are correct.
Answer: A
Explanation:
Explanation
Snowflake's zero-copy cloning feature provides a convenient way to quickly take a "snapshot" of any table, schema, or database and create a derived copy of that object which initially shares the underlying storage. This can be extremely useful for creating instant backups that do not incur any additional costs (until changes are made to the cloned object).
For example, when a clone is created of a table, the clone utilizes no data storage because it shares all the existing micro-partitions of the original table at the time it was cloned; however, rows can then be added, deleted, or updated in the clone independently from the original table. Each change to the clone results in new micro-partitions that are owned exclusively by the clone and are protect-ed through CDP.
NEW QUESTION # 29
Which privilege are required on an object (i.e. user or role) with USERADMIN Role can modify the object properties?
- A. OPEARTE
- B. MODIFY
- C. MANAGE GRANTS
- D. OWNERSHIP
Answer: D
NEW QUESTION # 30
Which Role that is dedicated to user and role management only?
- A. SECURITYADMIN
- B. SYSADMIN
- C. USERADMIN
- D. ORGADMIN
- E. PUBLIC
Answer: C
NEW QUESTION # 31
The following CREATE DATABASE command creates a clone of a database snowmy_db i.e.
Create database pods_db clone snowmy_db
before (statement => '7e5d0cb9-005e-94e6-b058-k8f5b37c5725');
What are possible reason of failing cloning operation for this database?
- A. SQL Compilation error: "Incorrect Syntax 'before' while creating database"
- B. Time Travel Statement query time is beyond the retention time of few current child (e.g., a table) of the Database entity.
- C. Time Travel Statement query time is at or before the point in time when the object was created.
- D. CREATE DATABASE query fails due to compilation error as it do not support state-ment keyword.
Answer: B,C
NEW QUESTION # 32
The COPY command supports several options for loading data files from a stage i.e.
I. By path
II. Specifying a list of specific files to load.
III. Using pattern matching to identify specific files by pattern.
IV. Organize files into logical paths that reflect a scheduling pattern.
Of the aforesaid options for identifying/specifying data files to load from a stage, which option in general is the fastest & best considerate?
- A. IV
- B. III
- C. I
- D. II
Answer: D
Explanation:
Explanation
Of the above options for identifying/specifying data files to load from a stage, providing a discrete list of files is generally the fastest; however, the FILES parameter supports a maximum of 1,000 files, meaning a COPY command executed with the FILES parameter can only load up to 1,000 files.
For example:
copy into load1 from @%load1/Snow1/ files=('mydata1.csv', 'mydata2.csv', 'mydata3.csv')
NEW QUESTION # 33
PARTITION_TYPE = USER_SPECIFIED must be used when you prefer to add and remove par-titions selectively rather than automatically adding partitions for all new files in an external storage location that match an expression?
- A. FALSE
- B. TRUE
Answer: B
Explanation:
Explanation
The CREATE EXTERNAL TABLE syntax for manually added partitions is as follows:
1.CREATE EXTERNAL TABLE
2.<table_name>
3.( <part_col_name> <col_type> AS <part_expr> )
4.[ , ... ]
5.[ PARTITION BY ( <part_col_name> [, <part_col_name> ... ] ) ]
6.PARTITION_TYPE = USER_SPECIFIED
Included the required PARTITION_TYPE = USER_SPECIFIED parameter.
NEW QUESTION # 34
A Data Engineer would like to define a file structure for loading and unloading data Where can the file structure be defined? (Select THREE)
- A. pipe object
- B. stage object
- C. INSERT command
- D. MERGE command
- E. copy command
- F. FILE FORMAT Object
Answer: B,E,F
Explanation:
Explanation
The places where the file format can be defined are copy command, file format object, and stage object. These places allow specifying or referencing a file format that defines how data files are parsed and loaded into or unloaded from Snowflake tables. A file format can include various options, such as field delimiter, field enclosure, compression type, date format, etc. The other options are not places where the file format can be defined. Option B is incorrect because MERGE command is a SQL command that can merge data from one table into another based on a join condition, but it does not involve loading or unloading data files. Option D is incorrect because pipe object is a Snowflake object that can load data from an external stage into a Snowflake table using COPY statements, but it does not define or reference a file format. Option F is incorrect because INSERT command is a SQL command that can insert data into a Snowflake table from literal values or subqueries, but it does not involve loading or unloading data files.
NEW QUESTION # 35
What is a characteristic of the operations of streams in Snowflake?
- A. When a stream is used to update a target table the offset is advanced to the current time.
- B. Querying a stream returns all change records and table rows from the current offset to the current time.
- C. Whenever a stream is queried, the offset is automatically advanced.
- D. Each committed and uncommitted transaction on the source table automatically puts a change record in the stream.
Answer: B
Explanation:
Explanation
A stream is a Snowflake object that records the history of changes made to a table. A stream has an offset, which is a point in time that marks the beginning of the change records to be returned by the stream. Querying a stream returns all change records and table rows from the current offset to the current time. The offset is not automatically advanced by querying the stream, but it can be manually advanced by using the ALTER STREAM command. When a stream is used to update a target table, the offset is advanced to the current time only if the ON UPDATE clause is specified in the stream definition. Each committed transaction on the source table automatically puts a change record in the stream, but uncommitted transactions do not.
NEW QUESTION # 36
How Data Engineer can do Monitoring of Files which are Staged Internally during Continuous data pipelines loading process? [Select all that apply]
- A. She can use the DATA_VALIDATE function to validate the data files She have loaded and can retrieve any errors encountered during the load.
- B. Snowflake retains historical data for COPY INTO commands executed within the pre-vious 14 days.
- C. She can use the DATA_LOAD_HISTORY Information Schema view to retrieve the history of data loaded into tables using the COPY INTO command.
- D. She can Monitor the status of each COPY INTO <table> command on the History tab page of the classic web interface.
- E. She Can Monitor the files using Metadata maintained by Snowflake i.e. file-name,last_modified date etc.
Answer: B,D,E
Explanation:
Explanation
Monitoring Files Staged Internally
Snowflake maintains detailed metadata for each file uploaded into internal stage (for users, tables, and stages), including:
File name
File size (compressed, if compression was specified during upload)
LAST_MODIFIED date, i.e. the timestamp when the data file was initially staged or when it was last modified, whichever is later In addition, Snowflake retains historical data for COPY INTO commands executed within the pre-vious 14 days. The metadata can be used to monitor and manage the loading process, including de-leting files after upload completes:
Use the LIST command to view the status of data files that have been staged.
Monitor the status of each COPY INTO <table> command on the History tab page of the classic web interface.
Use the VALIDATE function to validate the data files you've loaded and retrieve any errors en-countered during the load.
Use the LOAD_HISTORY Information Schema view to retrieve the history of data loaded into tables using the COPY INTO command.
NEW QUESTION # 37
What is a characteristic of the use of external tokenization?
- A. External tokenization cannot be used with database replication
- B. External tokenization allows (he preservation of analytical values after de-identification
- C. Pre-loading of unmasked data is supported with external tokenization
- D. Secure data sharing can be used with external tokenization
Answer: B
Explanation:
Explanation
External tokenization is a feature in Snowflake that allows users to replace sensitive data values with tokens that are generated and managed by an external service. External tokenization allows the preservation of analytical values after de-identification, such as preserving the format, length, or range of the original values.
This way, users can perform analytics on the tokenized data without compromising the security or privacy of the sensitive data.
NEW QUESTION # 38
......
Pass Snowflake DEA-C01 Exam in First Attempt Easily: https://www.ipassleader.com/Snowflake/DEA-C01-practice-exam-dumps.html
The Most Efficient DEA-C01 Pdf Dumps For Assured Success : https://drive.google.com/open?id=1bXooPv4UcW1at-Jo-S3S9QJrWM87XTOW