<< Prev Question Next Question >>

Question 29/68

You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Nyctaxi_raw. Nyctaxi_raw contains the following columns.

You create a Fabric notebook and attach it to lakehouse1.
You need to use PySpark code to transform the data. The solution must meet the following requirements:
* Add a column named pickupDate that will contain only the date portion of pickupDateTime.
* Filter the DataFrame to include only rows where fareAmount is a positive number that is less than 100.
How should you complete the code? To answer, select the appropriate options in the answer area. NOTE:
Each correct selection is worth one point.

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (68q)
Question 1: You have a Fabric warehouse named Warehouse1 that contains a...
Question 2: You have a Fabric workspace that contains a Dataflow Gen2 qu...
Question 3: You have a Fabric tenant that contains a workspace named Wor...
Question 4: You need to create a DAX measure to calculate the average ov...
Question 5: Note: This question is part of a series of questions that pr...
Question 6: You have a Fabric workspace that contains a DirectQuery sema...
Question 7: You are analyzing the data in a Fabric notebook. You have a ...
Question 8: You have a Fabric tenant You are creating a Fabric Data Fact...
Question 9: You have a Fabric tenant that contains a lakehouse. You are ...
Question 10: Your company has a finance department. You have a Fabric ten...
Question 11: You have a Microsoft Power B1 report and a semantic model th...
Question 12: You need to recommend which type of fabric capacity SKU meet...
Question 13: You have a Fabric tenant that contains a warehouse. Several ...
Question 14: You have a Fabric tenant that contains a workspace named Wor...
Question 15: You have a Fabric tenant that contains a machine learning mo...
Question 16: You are implementing a medallion architecture in a single Fa...
Question 17: You have a Fabric warehouse that contains a table named Sale...
Question 18: You have a Fabric tenant that contains a semantic model. The...
Question 19: You have a Fabric tenant that contains a data warehouse. You...
Question 20: You have a Microsoft Power Bl semantic model that contains m...
Question 21: You have a Fabric tenant You plan to create a data pipeline ...
Question 22: You have a Fabric tenant that contains a workspace named Wor...
Question 23: You have a Fabric tenant that contains a workspace named Wor...
Question 24: You have a Fabric tenant that contains a warehouse named War...
Question 25: You have a Fabric tenant that contains two workspaces named ...
Question 26: You have a Fabric tenant that contains a workspace named Wor...
Question 27: You have a Fabric workspace that contains a warehouse named ...
Question 28: You have a Fabric workspace named Workspace1 that contains a...
Question 29: You have a Fabric tenant that contains a lakehouse named Lak...
Question 30: You have a data warehouse that contains a table named Stage....
Question 31: You have source data in a CSV file that has the following fi...
Question 32: You have a Fabric tenant that contains a lakehouse named lak...
Question 33: You have a Fabric warehouse that contains a table named Sale...
Question 34: You need to recommend a solution to group the Research divis...
Question 35: You have source data in a folder on a local computer. You ne...
Question 36: You have a Fabric tenant that contains a lakehouse named lak...
Question 37: You have a Microsoft Power Bl project that contains a file n...
Question 38: You have a Fabric tenant that contains a data warehouse name...
Question 39: You have a Fabric tenant that contains 30 CSV files in OneLa...
Question 40: Note: This section contains one or more sets of questions wi...
Question 41: You are implementing two dimension tables named Customers an...
Question 42: You need to implement the date dimension in the data store. ...
Question 43: You have a Fabric tenant that contains a lakehouse named Lak...
Question 44: You have a Fabric tenant that contains a lakehouse. You plan...
Question 45: Note: This section contains one or more sets of questions wi...
Question 46: Which workspace rote assignments should you recommend for Re...
Question 47: You are creating a dataflow in Fabric to ingest data from an...
Question 48: You need to create a data loading pattern for a Type 1 slowl...
Question 49: You have a Fabric tenant that contains a lakehouse named Lak...
Question 50: You have a Fabric tenant that contains lakehouse named Lakeh...
Question 51: You have a Fabric tenant that contains JSON files in OneLake...
Question 52: You are the administrator of a Fabric workspace that contain...
Question 53: You have the source data model shown in the following exhibi...
Question 54: You have a Fabric tenant tha1 contains a takehouse named Lak...
Question 55: You have a Fabric tenant that contains a data pipeline. You ...
Question 56: You have a Fabric tenant that contains a semantic model. You...
Question 57: Note: This section contains one or more sets of questions wi...
Question 58: You have a Fabric tenant that contains a semantic model name...
Question 59: You have a Fabric tenant that contains a warehouse named WH1...
Question 60: You have a Fabric tenant that contains three users named Use...
Question 61: You have two Microsoft Power Bl queries named Employee and R...
Question 62: You have a Microsoft Fabric tenant that contains a dataflow....
Question 63: You have an Azure Data Lake Storage Gen2 account named stora...
Question 64: You to need assign permissions for the data store in the Ana...
Question 65: You have a Fabric notebook that has the Python code and outp...
Question 66: Note: This question is part of a series of questions that pr...
Question 67: You have a Fabric tenant that contains two lakehouses. You a...
Question 68: You have a Fabric workspace named Workspace 1 that contains ...