Question 136

You need to design a solution to meet the SQL Server storage requirements for CONT_SQL3.
Which type of disk should you recommend?
  • Question 137

    You are evaluating data storage solutions to support a new application.
    You need to recommend a data storage solution that represents data by using nodes and relationships in graph structures.
    Which data storage solution should you recommend?
  • Question 138

    Which consistency level should you use for Health Interface?
  • Question 139

    You are designing an Azure SQL Data Warehouse for a financial services company. Azure Active Directory will be used to authenticate the users.
    You need to ensure that the following security requirements are met:
    * Department managers must be able to create new database.
    * The IT department must assign users to databases.
    * Permissions granted must be minimized.
    Which role memberships should you recommend? To answer, drag the appropriate roles to the correct groups.
    Each role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
    NOTE: Each correct selection is worth one point.

    Question 140

    You are designing an app that will provide a data cleaning and supplementing service for customers. The app will use Azure Data Factory to run a daily process to read and write data from Azure Storage blob containers.
    You need to recommend an access mechanism for the customers to grant the app access to their data. The solution must meet the following requirements:
    * Provide access for a period of three months.
    * Restrict the app's access to specific containers.
    * Minimize administrative effort.
    * Minimize changes to the existing access controls of the customer's Azure Storage accounts.
    What should you recommend?