- All Exams Instant Download
table("uncleanedSales")
table("uncleanedSales")View AnswerAnswer: B Explanation: The answer is
You are currently asked to work on building a data pipeline, you have noticed that you are currently working on a very large scale ETL many data dependencies, which of the following tools can be used to address this problem?
You are currently asked to work on building a data pipeline, you have noticed that you are currently working on a very large scale ETL many data dependencies, which of the following tools can be used to address this problem?A . AUTO LOADER B. JOBS and TASKS C. SQL Endpoints...
ELSE (temp C 33 ) * 5/9 5.END
ELSE (temp C 33 ) * 5/9 5.ENDView AnswerAnswer: D Explanation: The answer is
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?A . MERGE INTO table_name B. COPY INTO table_name C. UPDATE table_name D. INSERT INTO OVERWRITE table_name E. INSERT IF EXISTS table_nameView AnswerAnswer: A Explanation:...
What is the purpose of a gold layer in Multi-hop architecture?
What is the purpose of a gold layer in Multi-hop architecture?A . Optimizes ETL throughput and analytic query performance B. Eliminate duplicate records C. Preserves grain of original data, without any aggregations D. Data quality checks and schema enforcement E. Powers ML applications, reporting, dashboards and adhoc reports.View AnswerAnswer: E...
ELSE (temp C 33 ) * 5/9 5.END
ELSE (temp C 33 ) * 5/9 5.ENDView AnswerAnswer: D Explanation: The answer is
Which of the following statements can be used to test the functionality of code to test number of rows in the table equal to 10 in python?
Which of the following statements can be used to test the functionality of code to test number of rows in the table equal to 10 in python? row_count = spark.sql("select count(*) from table").collect()[0][0]A . assert (row_count = 10, "Row count did not match") B. assert if (row_count = 10, "Row...
When using the complete mode to write stream data, how does it impact the target table?
When using the complete mode to write stream data, how does it impact the target table?A . Entire stream waits for complete data to write B. Stream must complete to write the data C. Target table cannot be updated while stream is pending D. Target table is overwritten for each...
What is the type of table created when you issue SQL DDL command CREATE TABLE sales (id int, units int)
What is the type of table created when you issue SQL DDL command CREATE TABLE sales (id int, units int)A . Query fails due to missing location B. Query fails due to missing format C. Managed Delta table D. External Table E. Managed Parquet tableView AnswerAnswer: C Explanation: Answer is...
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?A . MERGE INTO table_name B. COPY INTO table_name C. UPDATE table_name D. INSERT INTO OVERWRITE table_name E. INSERT IF EXISTS table_nameView AnswerAnswer: A Explanation:...
