You need to design an Azure SQL Database based on elastic pools. You are planning to create a table Employee having the data about the employees.For each record, there is an EmployeeID.You need to implement a data partitioning strategy based on the values in EmployeeID. You discuss with your friend and he suggests you to separate the data into Employee Departments via vertical partitioning. Will it help you in achieving the goal?

Answer options:

A.Yes
B.No

Correct Answer: B 
Using vertical partitioning in the given scenario won`t help in achieving the goal. Vertical partitioning is implemented for cross-database queries. As we need to partition the data based on EmployeeID, here horizontal partition9 should be used. Horizontal partitioning divides the data into partitions. Each partition is known as a shard and holds a subset of the specific data. 
Reference:
To know more about partitioning, please visit the below-given link: 

https://docs.microsoft.com/en-us/azure/architecture/best-practices/data-partitioning#designing-partitions-for-query-performance