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

Which of the following identifies multiple narrow operations that are executed in sequence?

Spark's execution/deployment mode determines where the driver and executors are physically located when a Spark application is run. Which of the following Spark execution/deploymen...

Which of the following will cause a Spark job to fail?

Which of the following best describes the similarities and differences between the MEMORY_ONLY storage level and the MEMORY_AND_DISK storage level?

Which of the following Spark properties is used to configure whether DataFrames found to be below a certain size threshold at runtime will be automatically broadcasted?

The code block shown below contains an error. The code block is intended to return a new DataFrame from DataFrame storesDF where column storeId is of the type string. Identify the...

Which of the following code blocks returns a new DataFrame where column division is the first two characters of column division in DataFrame storesDF?

The code block shown below should return a new DataFrame where column division from DataFrame storesDF has been renamed to column state and column managerName from DataFrame stores...

The code block shown below should return a new DataFrame where rows in DataFrame storesDF with missing values in every column have been dropped. Choose the response that correctly...

The code block shown below should return a collection of summary statistics for column sqft in DataFrame storesDF. Choose the response that correctly fills in the numbered blanks w...

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

Which of the following code blocks extracts the value for column sqft from the first row of DataFrame storesDF?

Which of the following code blocks uses SQL to return a new DataFrame containing column storeId and column managerName from a table created from DataFrame storesDF?

The code block shown below should adjust the number of partitions used in wide transformations like join() to 32. Choose the response that correctly fills in the numbered blanks wi...

Which of the following code blocks returns a DataFrame containing a column openDateString, a string representation of Java's SimpleDateFormat? Note that column openDate is of type...

Which of the following code blocks returns a new DataFrame that is the result of a cross join between DataFrame storesDF and DataFrame employeesDF?

Which of the following code blocks returns a new DataFrame that is the result of a position-wise union between DataFrame storesDF and DataFrame acquiredStoresDF?

In what order should the below lines of code be run in order to read a parquet at the file path filePath into a DataFrame? Lines of code: 1. storesDF 2. .load(filePath, source = "p...

The code block shown below should read a CSV at the file path filePath into a DataFrame with the specified schema schema. Choose the response that correctly fills in the numbered b...

Which of the following describes the Spark driver?

Which of the following describes the relationship between nodes and executors?

Which of the following will occur if there are more slots than there are tasks?

Which of the following is the most granular level of the Spark execution hierarchy?

Which of the following statements about Spark jobs is incorrect?

Which of the following operations is most likely to result in a shuffle?

The default value of spark.sql.shuffle.partitions is 200. Which of the following describes what that means?

Which of the following is the most complete description of lazy evaluation?

Which of the following code blocks applies the function assessPerformance() to each row of DataFrame storesDF?

The code block shown below contains an error. The code block is intended to print the schema of DataFrame storesDF. Identify the error. Code block: storesDF.printSchema.getAs[Strin...

Which of the following code blocks creates and registers a SQL UDF named "ASSESS_PERFORMANCE" using the Scala function assessPerformance() and applies it to column customerSatisfac...

The code block shown below should use SQL to return a new DataFrame containing column storeId and column managerName from a table created from DataFrame storesDF. Choose the respon...

The code block shown below contains an error. The code block intended to create a single- column DataFrame from Scala List years which is made up of integers. Identify the error. C...

Which of the following code blocks will always return a new 4-partition DataFrame from the 8- partition DataFrame storesDF without inducing a shuffle?

The code block shown below should return a new 12-partition DataFrame from DataFrame storesDF. Choose the response that correctly fills in the numbered blanks within the code block...

The code block shown below contains an error. The code block is intended to adjust the number of partitions used in wide transformations like join() to 32. Identify the error. Code...

The code block shown below contains an error. The code block intended to return a DataFrame containing a column dayOfYear, an integer representation of the day of the year from col...

Which of the following DataFrame operations is classified as an action?

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

Which of the following describes the difference between cluster and client execution modes?

Which of the following statements about Spark's stability is incorrect?

Which of the following cluster configurations is most likely to experience an out-of-memory error in response to data skew in a single partition? Note: each configuration has rough...

Of the following situations, in which will it be most advantageous to store DataFrame df at the MEMORY_AND_DISK storage level rather than the MEMORY_ONLY storage level?

A Spark application has a 128 GB DataFrame A and a 1 GB DataFrame B. If a broadcast join were to be performed on these two DataFrames, which of the following describes which DataFr...

Which of the following operations can be used to create a new DataFrame that has 12 partitions from an original DataFrame df that has 8 partitions?

Which of the following object types cannot be contained within a column of a Spark DataFrame?

Which of the following operations can be used to create a DataFrame with a subset of columns from DataFrame storesDF that are specified by name?

The code block shown below contains an error. The code block is intended to return a DataFrame containing all columns from DataFrame storesDF except for column sqft and column cust...

Which of the following describes slots?

Which of the following lists the units of work performed by Spark from largest to smallest?

Which of the following operations is least likely to result in a shuffle?