Question 6

You have an Azure Synapse Analystics dedicated SQL pool that contains a table named Contacts. Contacts contains a column named Phone.
You need to ensure that users in a specific role only see the last four digits of a phone number when querying the Phone column.
What should you include in the solution?
  • Question 7

    You are monitoring an Azure Stream Analytics job.
    You discover that the Backlogged Input Events metric is increasing slowly and is consistently non-zero.
    You need to ensure that the job can handle all the events.
    What should you do?
  • Question 8

    You need to trigger an Azure Data Factory pipeline when a file arrives in an Azure Data Lake Storage Gen2 container.
    Which resource provider should you enable?
  • Question 9

    You have an enterprise data warehouse in Azure Synapse Analytics.
    You need to monitor the data warehouse to identify whether you must scale up to a higher service level to accommodate the current workloads Which is the best metric to monitor?
    More than one answer choice may achieve the goal. Select the BEST answer.
  • Question 10

    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.