DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK Practice Questions

The code block shown below contains an error. The code block is intended to return a new DataFrame where column managerName from DataFrame storesDF is split at the space character...

The code block shown below should return a new DataFrame where single quotes in column storeSlogan have been replaced with double quotes. Choose the response that correctly fills i...

Which of the following code blocks returns a new DataFrame where column division from DataFrame storesDF has been replaced and renamed to column state and column managerName from D...

Which of the following code blocks returns a new DataFrame where column sqft from DataFrame storesDF has had its missing values replaced with the value 30,000? A sample of DataFram...

Which of the following operations can be used to return a DataFrame with no duplicate rows? Please select the most complete answer.

Which of the following code blocks returns a DataFrame where column divisionDistinct is the approximate number of distinct values in column division from DataFrame storesDF?

The code block shown below should return a new DataFrame with the mean of column sqft from DataFrame storesDF in column sqftMean. Choose the response that correctly fills in the nu...

Which of the following code blocks returns the number of rows in DataFrame storesDF for each unique value in column division?

Which of the following code blocks returns a DataFrame sorted alphabetically based on column division?

Which of the following code blocks returns a 10 percent sample of rows from DataFrame storesDF with replacement?

Which of the following code blocks returns the first 3 rows of DataFrame storesDF?

The code block shown below should return a new DataFrame that is the result of an inner join between DataFrame storeDF and DataFrame employeesDF on column storeId. Choose the respo...

The code block shown below should return a new DataFrame that is the result of an outer join between DataFrame storesDF and DataFrame employeesDF on column storeId. Choose the resp...

Which of the following code blocks fails to return a new DataFrame that is the result of an inner join between DataFrame storesDF and DataFrame employeesDF on column storeId and co...

The code block shown below should efficiently perform a broadcast join of DataFrame storesDF and the much larger DataFrame employeesDF using key column storeId. Choose the response...

Which of the following operations performs a cross join on two DataFrames?

Which of the following code blocks writes DataFrame storesDF to file path filePath as CSV?

Which of the following code blocks writes DataFrame storesDF to file path filePath as parquet and partitions by values in column division?

Of the following, which is the coarsest level in the Spark execution hierarchy?

Which of the following statements about slots is incorrect?

Which of the following code blocks returns a new Data Frame from DataFrame storesDF with no duplicate rows?

The code block shown below contains an error. The code block is intended to return the exact number of distinct values in column division in DataFrame storesDF. Identify the error....

Which of the following code blocks returns the number of rows in DataFrame storesDF for each distinct combination of values in column division and column storeCategory?

The code block shown below contains an error. The code block is intended to return a collection of summary statistics for column sqft in Data Frame storesDF. Identify the error. Co...

The code block shown below should extract the integer value for column sqft from the first row of DataFrame storesDF. Choose the response that correctly fills in the numbered blank...

The code block shown below should print the schema of DataFrame storesDF. Choose the response that correctly fills in the numbered blanks within the code block to complete this tas...

The code block shown below contains an error. The code block is intended to create and register a SQL UDF named "ASSESS_PERFORMANCE" using the Scala function assessPerformance() an...

The code block shown below contains an error. The code block is intended to create the Scala UDF assessPerformanceUDF() and apply it to the integer column customers1t1sfaction in D...

The code block shown below should create a single-column DataFrame from Scala list years which is made up of integers. Choose the response that correctly fills in the numbered blan...

The code block shown below should cache DataFrame storesDF only in Spark's memory. Choose the response that correctly fil ls in the numbered blanks within the code block to complet...

Which of the following code blocks returns a DataFrame containing a column month, an integer representation of the day of the year from column openDate from DataFrame storesDF. Not...

The code block shown below contains an error. The code block intended to return a new DataFrame that is the result of an inner join between DataFrame storesDF and DataFrame employe...

Which of the following pairs of arguments cannot be used in DataFrame.join() to perform an inner join on two DataFrames, named and aliased with "a" and "b" respectively, to specify...

The code block shown below contains an error. The code block is intended to return a new DataFrame that is the result of a position-wise union between DataFrame storesDF and DataFr...

Which of the following code blocks writes DataFrame storesDF to file path filePath as parquet overwriting any existing files in that location?

Which of the following code blocks reads a CSV at the file path filePath into a Data Frame with the specified schema schema?

Which of the following code blocks returns a DataFrame containing only the rows from DataFrame storesDF where the value in column sqft is less than or equal to 25,000 AND the value...

Which of the following sets of DataFrame methods will both return a new DataFrame only containing rows that meet a specified logical condition?

The code block shown below should return a DataFrame containing all columns from DataFrame storesDF except for column sqft and column customerSatisfaction. Choose the response that...

Which of the following describes the difference between DataFrame.repartition(n) and DataFrame.coalesce(n)?

Which of the following cluster configurations is most likely to experience delays due to garbage collection of a large Dataframe? Note: each configuration has roughly the same comp...

Which of the following DataFrame operations is classified as a transformation?

Which of the following operations will fail to trigger evaluation?

Of the following, which is the coarsest level in the Spark execution hierarchy?

Which of the following code blocks returns a new DataFrame with a new column customerSatisfactionAbs that is the absolute value of column customerSatisfaction in DataFrame storesDF...

Which of the following statements about the Spark driver is true?

The code block shown below should write DataFrame storesDF to file path filePath as parquet and partition by values in column division. Choose the response that correctly fills in...

Which of the following types of processes induces a stage boundary?

Which of the following cluster configurations will induce the least network traffic during a shuffle operation? Note: each configuration has roughly the same compute power using 10...

Which of the following describes a partition?