Particularly difficult questions

Question 1

You are importing data into an Azure Synapse Analytics database. The data is being inserted by using PolyBase.

You need to maximize network throughput for the import process.

What should you use?
-Sharding
-Vertical Partitioning
-Horizontal Partitioning
-Functional Partitioning

Answer 1

Shard the source data across multiple files. Sharding the source data into multiple files will increase the amount of bandwidth available to the import process.

Question 2

You have an app named App1 that contains two datasets named dataset1 and dataset2. App1 frequently queries dataset1. App1 infrequently queries dataset2.

You need to prevent queries to dataset2 from affecting the buffer pool and aging out the data in dataset1.

Which type of partitioning should you use?
-Vertical Partitioning
-Horizontal Partitioning
-Functional Partitioning

Answer 2

vertical - By using vertical partitioning, different parts of the database can be isolated from each other to improve cache use.

Question 3

You are designing a database solution that will host data for multiple business units.

You need to ensure that queries from one business unit do not affect the other business units.

Which type of partitioning should you use?
-Vertical Partitioning
-Horizontal Partitioning
-Functional Partitioning

Answer 3

functional - By using functional partitioning, different users of the database can be isolated from each other to ensure that one business unit does not affect another business unit.

Question 4

You have an Azure Synapse Analytics database named DB1.

You plan to import data into DB1.

You need to maximize the performance of the data import.

What should you implement?
- Functional Partitioning
- Vertical Partitioning
- Horizontal Partitioning

Answer 4

Horizontal Partitioning - By using horizontal partitioning, you can improve the performance of the data load. As more server resources and bandwidth are available to the source files, the import process gets faster

Question 5

You plan to deploy an app that will distribute files across multiple Azure Storage accounts.

You need to recommend a partitioning strategy that meets the following requirements:

Optimizes the data distribution balance.
Minimizes the creation of extra tables.
What should you recommend?
- Hash
- Lookup
- Sharding

Answer 5

Hash - Hash partitioning is optimized for data distribution and uses a hash function to eliminate the need for a lookup table.