Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Databricks Certified Associate Developer for Apache Spark

Databricks Certified Associate Developer for Apache Spark Exam Practice Questions (P. 5)

  • Full Access (207 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #21
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 OR the value in column customerSatisfaction is greater than or equal to 30?
  1. A
    storesDF.filter(col("sqft") <= 25000 | col("customerSatisfaction") >= 30)
  2. B
    storesDF.filter(col("sqft") <= 25000 or col("customerSatisfaction") >= 30)
  3. C
    storesDF.filter(sqft <= 25000 or customerSatisfaction >= 30)
  4. D
    storesDF.filter(col(sqft) <= 25000 | col(customerSatisfaction) >= 30)
  5. E
    storesDF.filter((col("sqft") <= 25000) | (col("customerSatisfaction") >= 30))

Correct Answer:
E

Question #22
Which of the following code blocks returns a new DataFrame from DataFrame storesDF where column storeId is of the type string?
  1. A
    storesDF.withColumn("storeId, cast(col("storeId"), StringType()))
  2. B
    storesDF.withColumn("storeId, col("storeId").cast(StringType()))
  3. C
    storesDF.withColumn("storeId, cast(storeId).as(StringType)
  4. D
    storesDF.withColumn("storeId, col(storeId).cast(StringType)
  5. E
    storesDF.withColumn("storeId, cast("storeId").as(StringType()))

Correct Answer:
B

Question #23
Which of the following code blocks returns a new DataFrame with a new column employeesPerSqft that is the quotient of column numberOfEmployees and column sqft, both of which are from DataFrame storesDF? Note that column employeesPerSqft is not in the original DataFrame storesDF.
  1. A
    storesDF.withColumn("employeesPerSqft", col("numberOfEmployees") / col("sqft"))
  2. B
    storesDF.withColumn("employeesPerSqft", "numberOfEmployees" / "sqft")
  3. C
    storesDF.select("employeesPerSqft", "numberOfEmployees" / "sqft")
  4. D
    storesDF.select("employeesPerSqft", col("numberOfEmployees") / col("sqft"))
  5. E
    storesDF.withColumn(col("employeesPerSqft"), col("numberOfEmployees") / col("sqft"))

Correct Answer:
A

Question #24
The code block shown below should return a new DataFrame from DataFrame storesDF where column modality is the constant string "PHYSICAL", Assume DataFrame storesDF is the only defined language variable. Choose the response that correctly fills in the numbered blanks within the code block to complete this task.
Code block:
storesDF. _1_(_2_,_3_(_4_))
  1. A
    1. withColumn
    2. "modality"
    3. col
    4. "PHYSICAL"
  2. B
    1. withColumn
    2. "modality"
    3. lit
    4. PHYSICAL
  3. C
    1. withColumn
    2. "modality"
    3. lit
    4. "PHYSICAL"
  4. D
    1. withColumn
    2. "modality"
    3. SrtringType
    4. "PHYSICAL"
  5. E
    1. newColumn
    2. modality
    3. SrtringType
    4. PHYSICAL

Correct Answer:
C

Question #25
Which of the following code blocks returns a DataFrame where column storeCategory from DataFrame storesDF is split at the underscore character into column storeValueCategory and column storeSizeCategory?
A sample of DataFrame storesDF is displayed below:
  1. A
    (storesDF.withColumn("storeValueCategory", split(col("storeCategory"), "_")[1])
    .withColumn("storeSizeCategory", split(col("storeCategory"), "_")[2]))
  2. B
    (storesDF.withColumn("storeValueCategory", col("storeCategory").split("_")[0])
    .withColumn("storeSizeCategory", col("storeCategory").split("_")[1]))
  3. C
    (storesDF.withColumn("storeValueCategory", split(col("storeCategory"), "_")[0])
    .withColumn("storeSizeCategory", split(col("storeCategory"), "_")[1]))
  4. D
    (storesDF.withColumn("storeValueCategory", split("storeCategory", "_")[0])
    .withColumn("storeSizeCategory", split("storeCategory", "_")[1]))
  5. E
    (storesDF.withColumn("storeValueCategory", col("storeCategory").split("_")[1])
    .withColumn("storeSizeCategory", col("storeCategory").split("_")[2]))

Correct Answer:
C

Previous Questions Next Questions

All Pages