Your company needs to design a database that shows how changes traffic in one area of a network affect other components on the network.
Which type of data store should you use?
Match the security components to the appropriate scenarios.
To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.



Reference:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-windows-firewall-for-database-engine-access?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/a zure-sql/database/authentication-aad-overview
https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-certificate-store-configure
Which statement is an example of Data Manipulation Language (DML)?
You have a quality assurance application that reads data from a data warehouse.
Which type of processing does the application use?
Select the answer that correctly completes the sentence.

Explanation:
Answer below as:

Which statement is an example of Data Manipulation Language (DML)?
Blob rehydration occurs in Azure Blob storage when a blob moves between which access tiers?
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.


Explanation:
Box 1: Yes
Batch processing refers to processing of high volume of data in batch within a specific time span. It processes large volume of data all at once. Batch processing is used when data size is known and finite. It takes little longer time to processes data.
Box 2: Yes
Stream processing refers to processing of continuous stream of data immediately as it is produced. It analyzes streaming data in real time. Stream processing is used when the data size is unknown and infinite and continuous.
Box 3: No
Reference:
https://www.geeksforgeeks.org/difference-between-batch-processing-and-stream-processing/
Match the data terms to the appropriate descriptions.
To answer, drag the term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.


Explanation:









