You need to design the partitions for the product sales transactions. The solution must mee the sales transaction dataset requirements.
What should you include in the solution? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

A company plans to use Platform-as-a-Service (PaaS) to create the new data pipeline process. The process must meet the following requirements:
Ingest:
* Access multiple data sources.
* Provide the ability to orchestrate workflow.
* Provide the capability to run SQL Server Integration Services packages.
Store:
* Optimize storage for big data workloads.
* Provide encryption of data at rest.
* Operate with no size limits.
Prepare and Train:
* Provide a fully-managed and interactive workspace for exploration and visualization.
* Provide the ability to program in R, SQL, Python, Scala, and Java.
* Provide seamless user authentication with Azure Active Directory.
Model & Serve:
* Implement native columnar storage.
* Support for the SQL language
* Provide support for structured streaming.
You need to build the data integration pipeline.
Which technologies should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation
Graphical user interface, application, table, email Description automatically generated

Comment: *

Name: *

Email: *

Verification: *

You are designing an Azure Synapse Analytics dedicated SQL pool.
Groups will have access to sensitive data in the pool as shown in the following table.

You have policies for the sensitive dat
a. The policies vary be region as shown in the following table.

You have a table of patients for each region. The tables contain the following potentially sensitive columns.

You are designing dynamic data masking to maintain compliance.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview

Comment: *

Name: *

Email: *

Verification: *

You implement an enterprise data warehouse in Azure Synapse Analytics.
You have a large fact table that is 10 terabytes (TB) in size.
Incoming queries use the primary key SaleKey column to retrieve data as displayed in the following table:

You need to distribute the large fact table across multiple nodes to optimize performance of the table.
Which technology should you use?

• A.hash distributed table with clustered index
• B.hash distributed table with clustered Columnstore index
• C.round robin distributed table with clustered index
• D.round robin distributed table with clustered Columnstore index
• E.heap table with distribution replicate

Comment: *

Name: *

Email: *

Verification: *

You have an Azure Synapse Analytics dedicated SQL pool named SA1 that contains a table named Table1. You need to identify tables that have a high percentage of deleted rows. What should you run?
A)

B)

C)

D)

• A.Option
• B.Option
• C.Option
• D.Option

Comment: *

Name: *

Email: *

Verification: *