You have a dataset internet_sales that represents the online sale of the products. Your manager asks you to divide this dataset by date i.e. in two datasets one having the sales before or equal to 03/31/2021 and one after that. Which of the following split modes will you use? (Note: the dataset is having a column named date with format mmddyyyy)

Answer options:

A.Split Rows
B.Split Columns
C.Recommender Split
D.Regular Expression Split
E.Relative Expression Split

Correct Answer: E 
Relative Expression Split option is used wherever you need to apply a condition to a number column. This number can be a time/date field, a column representing dollar amount or age, or even a percentage. For example: The expression \"Date" > 03/31/2010 will select all the rows with the sale after 31st march.
Option A is incorrect. This option is used for dividing the data into 2 parts. You can mention the percentage that how much data should be there in each split. If you don’t mention it, by default data is split 50-50.
Option B is incorrect. There is no such splitting mode as split columns.
Option C is incorrect. The recommender Split option is used to prepare the data for a recommender system.
Option D is incorrect. Regular Expression Split is used to divide the dataset by testing a single column for a value.
Option E is correct. In the given scenario, as we need to apply a condition on a number column i.e Date, the Relative Expression Split option should be used.
References: 
To know more about splitting a dataset, please visit the below-given links: 

https://docs.microsoft.com/en-us/azure/machine-learning/studio-module-reference/split-data
https://docs.microsoft.com/en-us/azure/machine-learning/studio-module-reference/split-data-using-relative-expression