AZ-305 Exam Question 81

You need to design a highly available Azure SQL database that meets the following requirements:
Failover between replicas of the database must occur without any data loss.
The database must remain available in the event of a zone outage.
Costs must be minimized
Which deployment option should you use?
  • AZ-305 Exam Question 82

    The accounting department at your company migrates to a new financial accounting software. The accounting department must keep file-based database backups for seven years for compliance purposes. It is unlikely that the backups will be used to recover data.
    You need to move the backups to Azure. The solution must minimize costs.
    Where should you store the backups?
  • AZ-305 Exam Question 83

    You have to deploy an Azure SQL database named db1 for your company. The databases must meet the following security requirements When IT help desk supervisors query a database table named customers, they must be able to see the full number of each credit card When IT help desk operators query a database table named customers, they must only see the last four digits of each credit card number A column named Credit Card rating in the customers table must never appear in plain text in the database system. Only client applications must be able to decrypt the information that is stored in this column Which of the following can be implemented for the Credit Card rating column security requirement?
  • AZ-305 Exam Question 84

    Your company, named Contoso, Ltd., has an Azure subscription that contains the following resources:
    * An Azure Synapse Analytics workspace named contosoworkspacel
    * An Azure Data Lake Storage account named contosolakel
    * An Azure SQL database named contososql1
    The product data of Contoso is copied from contososqM to contosolakel.
    Contoso has a partner company named Fabrikam Inc. Fabrikam has an Azure subscription that contains the following resources:
    * A virtual machine named FabrikamVMI that runs Microsoft SQL Server 2019
    * An Azure Storage account named fabrikamsal
    Contoso plans to upload the research data on FabrikamVMI to contosolakel. During the upload, the research data must be transformed to the data formats used by Contoso.
    The data in contosolakel will be analyzed by using contosoworkspacel.
    You need to recommend a solution that meets the following requirements:
    * Upload and transform the FabrikamVMI research data.
    * Provide Fabrikam with restricted access to snapshots of the data in contosoworkspace1.
    What should you recommend for each requirement? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    AZ-305 Exam Question 85

    You need to recommend a solution to meet the database retention requirement. What should you recommend?