Which of the following SQL statement can be used to query a table by eliminating duplicate rows from the query results?

• A.SELECT DISTINCT * FROM table_name
• B.SELECT DISTINCT * FROM table_name HAVING COUNT(*) > 1
• C.SELECT DISTINCT_ROWS (*) FROM table_name
• D.SELECT * FROM table_name GROUP BY * HAVING COUNT(*) < 1
• E.SELECT * FROM table_name GROUP BY * HAVING COUNT(*) > 1

Comment: *

Name: *

Email: *

Verification: *

Your colleague was walking you through how a job was setup, but you noticed a warning message that said,
"Jobs running on all-purpose cluster are considered all purpose compute", the colleague was not sure why he was getting the warning message, how do you best explain this warning mes-sage?

• A.All-purpose clusters cannot be used for Job clusters, due to performance issues.
• B.All-purpose clusters take longer to start the cluster vs a job cluster
• C.All-purpose clusters are less expensive than the job clusters
• D.All-purpose clusters are more expensive than the job clusters
• E.All-purpose cluster provide interactive messages that can not be viewed in a job

Correct Answer: D

Explanation
Warning message:
Graphical user interface, text, application, email Description automatically generated

Pricing for All-purpose clusters are more expensive than the job clusters AWS pricing(Aug 15th 2022)Graphical user interface Description automatically generated

Bottom of Form
Top of Form

Comment: *

Name: *

Email: *

Verification: *

How VACCUM and OPTIMIZE commands can be used to manage the DELTA lake?

• A.VACCUM command can be used to compact small parquet files, and the OP-TIMZE command can be used to delete parquet files that are marked for dele-tion/unused.
• B.VACCUM command can be used to delete empty/blank parquet files in a delta table. OPTIMIZE command can be used to update stale statistics on a delta table.
• C.VACCUM command can be used to compress the parquet files to reduce the size of the table, OPTIMIZE command can be used to cache frequently delta tables for better performance.
• D.VACCUM command can be used to delete empty/blank parquet files in a delta table, OPTIMIZE command can be used to cache frequently delta tables for better perfor-mance.
• E.OPTIMIZE command can be used to compact small parquet files, and the VAC-CUM command can be used to delete parquet files that are marked for deletion/unused.
  (Correct)

Comment: *

Name: *

Email: *

Verification: *

You are currently asked to work on building a data pipeline, you have noticed that you are currently working with a data source that has a lot of data quality issues and you need to monitor data quality and enforce it as part of the data ingestion process, which of the following tools can be used to address this problem?

• A.AUTO LOADER
• B.DELTA LIVE TABLES
• C.JOBS and TASKS
• D.UNITY Catalog and Data Governance
• E.STRUCTURED STREAMING with MULTI HOP

Comment: *

Name: *

Email: *

Verification: *

What is the main difference between the below two commands?
1.INSERT OVERWRITE table_name
2.SELECT * FROM table
1.CREATE OR REPLACE TABLE table_name
2.AS SELECT * FROM table

• A.INSERT OVERWRITE replaces data by default, CREATE OR REPLACE replaces data and Schema by default
• B.INSERT OVERWRITE replaces data and schema by default, CREATE OR REPLACEreplaces data by default
• C.INSERT OVERWRITE maintains historical data versions by de-fault, CREATE OR REPLACEclears the historical data versions by default
• D.INSERT OVERWRITE clears historical data versions by de-fault, CREATE OR REPLACE maintains the historical data versions by default
• E.Both are same and results in identical outcomes

Comment: *

Name: *

Email: *

Verification: *