Free DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK Web TestEngine Demo

Q33 Single choice

The code block shown below should return a column that indicates through boolean variables whether rows in DataFrame transactionsDf have values greater or equal to 20 and smaller or equal to 30 in column storeId and have the value 2 in column productId. Choose the answer that correctly fills the blanks in the code block to accomplish this.

transactionsDf.__1__((__2__.__3__) __4__ (__5__))

A
1. select
2. col("storeId")
3. between(20, 30)
4. and
5. col("productId")==2
B
1. where
2. col("storeId")
3. geq(20).leq(30)
4. &
5. col("productId")==2
C
1. select
2. "storeId"
3. between(20, 30)
4. &&
5. col("productId")==2
D
1. select
2. col("storeId")
3. between(20, 30)
4. &&
5. col("productId")=2
E
1. select
2. col("storeId")
3. between(20, 30)
4. &
5. col("productId")==2

DATABRICKS-CERTIFIED-ASSOCIATE-DEVELOPER-FOR-APACHE-SPARK Web TestEngine demo