DRAG DROP -You need to implement the encryption for SALESDB.Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.Select and Place:
DRAG DROP -You manage security for a database that supports a line of business application.Private and personal data stored in the database must be protected and encrypted.You need to configure the database to use Transparent Data Encryption (TDE).Which five actions should you perform in sequence? To answer, select the appropriate actions from the list of actions to the answer area and arrange them in the correct order.Select and Place:
Which windowing function should you use to perform the streaming aggregation of the sales data?
You have to create a new single database instance of Microsoft Azure SQL database. You must ensure that client connections are accepted via a workstation.The workstation will use SQL Server Management Studio to connect to the database instance.Which of the following Powershell commands would you execute to create and configure the database? (Choose three.)
Note: This question is a part of series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.You develop a data ingestion process that will import data to an enterprise data warehouse in Azure Synapse Analytics. The data to be ingested resides in parquet files stored in an Azure Data Lake Gen 2 storage account.You need to load the data from the Azure Data Lake Gen 2 storage account into the Data Warehouse.Solution:1. Create an external data source pointing to the Azure storage account2. Create a workload group using the Azure storage account name as the pool name3. Load the data using the INSERT`¦SELECT statementDoes the solution meet the goal?
How should you monitor SALESDB to meet the technical requirements?
