70-473 | Pinpoint 70-473 Exam Questions and Answers 2021

for Microsoft certification, Real Success Guaranteed with Updated . 100% PASS 70-473 Designing and Implementing Cloud Data Platform Solutions exam Today!

Microsoft 70-473 Free Dumps Questions Online, Read and Test Now.

NEW QUESTION 1
You have a Microsoft Azure SQL database.
You need to ensure that you can use the Always Encrypted feature for the database.
Which two components should you configure? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  • A. the Column Master Key
  • B. the database master key
  • C. the service master key
  • D. transparent data encryption (TDE)
  • E. the Column Encryption Key

Answer: A

Explanation: References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-always-encrypted/

NEW QUESTION 2
You have a Microsoft Azure virtual machine named SQL1 that has Microsoft SQL Server 2021 installed. SQL1 has a critical database that contains online transaction data. The database is 700 GB.
You regularly perform full database backups.
On a separate Azure virtual machine, you run a test restore procedure of the database and discover that restoring the database takes longer than expected.
You need to reduce the amount of time required to restore the database. What should you do?

  • A. Modify the backup solution to use differential database backups.
  • B. Partition the tables in the database, and then modify the backup solution to use incremental backups.
  • C. Create multiple filegroups in the database, and then modify the backup solution to use filegroup backups.
  • D. Modify the backup solution to use transaction log backups.

Answer: C

NEW QUESTION 3
You have an AlwaysOn availability group between several Microsoft Azure virtual machines. You need to ensure that the databases meet the following requirements:
The solution must prevent any disruption to replication.
Which four actions should you perform in sequence? I answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
70-473 dumps exhibit

    Answer:

    Explanation: References:
    https://blogs.msdn.microsoft.com/alwaysonpro/2014/01/28/how-to-enable-tde-encryption-on-a-database-in-an-a

    NEW QUESTION 4
    You need to identify which methods to use to migrate MovieReviewDB and CWDB.
    Which method should you identify for each database? To answer, select the appropriate options in the answer area.
    70-473 dumps exhibit

      Answer:

      Explanation: References:
      https://azure.microsoft.com/en-gb/documentation/articles/sql-database-cloud-migrate-compatible-using-ssms-mi

      NEW QUESTION 5
      A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04.
      You are evaluating the use of active geo-replication for one of the research department databases. You need to identify which service tier to use for the database. The solution must meet the department
      requirements and the business requirements.
      What should you identify?

      • A. Premium 1
      • B. Premium 14
      • C. Standard S0
      • D. Basic

      Answer: C

      Explanation: References:
      https://azure.microsoft.com/en-gb/documentation/articles/sql-database-service-tiers/

      Topic 4, Relecloud
      Overview
      General overview
      Relecloud is an international data services company that has 3,000 users. The company has a sale department a marketing department a research department and a human resources department.
      Physical location
      Relecloud has one office in Seattle. The company has customers through cut North America and Europe. Relecloud has most of its computing infrastructure located in a datacenter in Los Angeles. The company also
      has a few servers that are configured as Microsoft Azure virtual machines.
      Existing Environment
      Active Directory
      The network contains an active Directory forest named relecloud.com. The forest contains two domains named relecloud.com and relecloud local. The functional level of the domain is Window Server 2008 R2.
      Each office contains five domain controllers. Each office is configured as an Active Directory site. Current business model
      Relecloud maintains a single Microsoft SQL Server database named Database 1. Database 1 hosts all of the data for the customers of Relecloud. Database 1 has a total of 600 GB of data.
      Relecloud provides data for its customers by using several method of delivery. such as comma-separated value (CSV) files and fixed-width text files. All of the files are delivered by using file Transfer protocol (FTP) or Secure FTP (SFTP).
      The SQL Server environment contains two on-premises servers and one server in the Azure region of US West. The Azure of US West, The Azure infrastructure contains an ExpressRoute connection.
      The network contains the SQL server configured as shown in the following table.
      70-473 dumps exhibit
      ServerDB1 and Server DB2 are members of an availability group. Problem statements
      Relecloud identifies several issues with its current data storage model. Multiple customers report that they have issues loading files into relational databases. Additionally, Relecloud administrators often fail to
      communicate with the FTP servers of the Relecloud customers.
      Currently, the memory and the CPU of ServerDB1 and ServerDB2 are nearly fully utilized.
      Requirements
      Business goals
      Relecloud plans to take a leadership role in its industry and modernize its delivery method. The company also plans to offer its customers easier access to its data.
      Planned changes
      Relecloud plans to move all of its customers to a delivery model that uses Azure SQL Database and plans to maintain a single database for each customer.
      Relecloud plans to automate the process of creating the required infrastructure for each new customers is approximately 10 GB and has a static size. The new customers require a rapid response time to database queries and each customer has five to concurrent logins.
      Security requirements
      Relecloud identifies the following security requirements: Customers must be able to read data only.
      Customers must be able to create custom views.
      Customers must be able to use two-factor authentication when accessing Azure SQL databases. Technical requirements
      Relecloud identifies the following technical requirements:
      Database administrators must be notified when the CPU pressure of AzD801 must be able to respond to customer requests for data.
      Auditing requirements:
      All of the requests from the stored procedures that are run against the Azure SQL databases must be logged. All auditing information must be viewable in Microsoft Excel in Real-time.

      NEW QUESTION 6
      You need to deploy a new Microsoft Azure SQL database that must meet the following requirements:
      * Will be available it a single Azure region becomes unavailable
      * Will be able to fail over to another Azure region automatically
      Which two configuration tasks should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

      • A. Add the database to a failover group.
      • B. Add the database to a database pool.
      • C. Configure the database connection string to point to the endpoint of the read-write listener.
      • D. Add the database to an AlwaysOn availability group that uses synchronous replication.
      • E. Configure the database connection string to point to the endpoint of the primary replica.

      Answer: AD

      NEW QUESTION 7
      Users at Relecloud report slow performance when viewing reports from AzD801. You need to identify the cause of the performance issue as quickly as possible.
      Which dynamic management view and performance monitor counter should you use? To answer, select the appropriate options in the answers area.
      NOTE: Each correct selection is worth one point.
      70-473 dumps exhibit

        Answer:

        Explanation: Box 1: Sys.dm_io_virtual_file_stats
        Sys.dm_io_virtual_file_stats returns I/O statistics for data and log files. Box 2:
        Page reads/sec indicates the number of physical database page reads that are issued per second. This statistic displays the total number of physical page reads across all databases. Because physical I/O is expensive, you may be able to minimize the cost, either by using a larger data cache, intelligent indexes, and more efficient queries, or by changing the database design.
        Reference:
        https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-io-virtual https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/monitor-cpu-usage?view=sql-ser

        NEW QUESTION 8
        You have a Microsoft Azure SQL database named Database1.
        You need to implement the Always Encrypted feature for Database1.
        In which sequence should you execute the code blocks? To answer, move all the code blocks from the list of code blocks to the answer area and arrange them in the correct order.
        70-473 dumps exhibit

          Answer:

          Explanation: 70-473 dumps exhibit

          NEW QUESTION 9
          You have an organizational data mart that contains 3.5 TB of uncompressed data.
          The size of the data is expected to grow 2 annually. Reporting is performed only during business hours. You plan to move the data to the cloud.
          You need to design a cloud architecture for the data mart. The solution must minimize costs and administrative overhead.
          What is the best design to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.

          • A. a Microsoft Azure SQL data warehouse
          • B. a Microsoft SQL Server virtual machine
          • C. a Microsoft Azure HDInsight cluster
          • D. a Microsoft Azure SQL database

          Answer: A

          Explanation: References:
          https://azure.microsoft.com/en-gb/documentation/articles/sql-data-warehouse-overview-what-is/

          NEW QUESTION 10
          You are evaluating the migration of an on-premises Microsoft SQL server database to a Microsoft Azure SQL database.
          You need to identity the minimum service tier required to host the database.
          Which three metrics should you evaluate? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

          • A. the concurrent sessions
          • B. the I/Q latencies
          • C. the number of worker threads
          • D. the max degree of parallelism
          • E. the database size

          Answer: ABD

          NEW QUESTION 11
          You need to implement a storage architecture for the Azure virtual machines that will host the OLTP database. The solution must meet the business goals and the technical requirements.
          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.
          70-473 dumps exhibit

            Answer:

            Explanation: 70-473 dumps exhibit

            NEW QUESTION 12
            Your company has two offices located in London and New York.
            The London office has a public IP of 131.107.1.1 and a private IP subnet of 192.168.4.0/24. The New York office has a public IP of 131.107.15.1 and a private IP subnet of 192.168.8.0/24.
            You have a Microsoft Azure SQL database. Currently, only the users in the London office use the database. You plan to provide the users in the New York office with access to the database.
            You need to ensure that the New York office users can access the database. Which command should you execute?

            • A. EXECUTE sp_set_database_firewall_rule N’NewYork,’131.107.15.1’,’255.255.255.255’
            • B. EXECUTE sp_set_database_firewall_rule N’NewYork, ’192.168.8.0’, ‘192.168.8.255’;
            • C. EXECUTE sp_set_database_firewall_rule N’NewYork,’192.168.8.0’, ’255.255.255.0’;
            • D. EXECUTE sp_set_database_firewall_rule N’NewYork,’131.107.15.1’,’131.107.15.1’;

            Answer: B

            Explanation: References:
            http://azure.patrickkeisler.com/2015/11/configuring-the-azure-sql-database-firewall/
            https://msdn.microsoft.com/en-gb/library/dn270010.aspx

            NEW QUESTION 13
            You plan to migrate an on-premises database to Microsoft Azure. The planned deployment will include an Always On Failover Cluster Instance of Microsoft SQL Server.
            You need to implement a storage solution for the planned deployment. Which storage solution should you implement?

            • A. Azure Table Storage
            • B. Storage Spaces Direct
            • C. Azure Blob storage
            • D. SAN virtualization

            Answer: B

            Explanation: References:
            https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/always-on-failover-cluster-instances-s

            NEW QUESTION 14
            Your environment contains a Microsoft Azure machine that has Microsoft SQL Server Standard installed.
            An application named App1 uses the data stored in SQL server. The Service level Agreement (SLA) for App1 states that the application can lose a maximum of 10 minutes of data and that the data must be available if two
            Azure regions fail.
            You need to implement a solution that provides disaster recovery for App1.
            In two other Azure regions, you deploy an Azure virtual machine that has SQL Server installed. What should you implement next?

            • A. Merge Replication
            • B. AlwaysOn Failover Cluster Instances
            • C. AlwaysOn Availability Groups
            • D. Log Shipping

            Answer: D

            NEW QUESTION 15
            Your network contains a primary site that has an AlwaysOn Availability Group.
            You plan to create a new Microsoft Azure subscription that will use AlwaysOn Availability Groups on Microsoft Azure virtual machines.
            You need to ensure that you can activate AlwaysOn Availability Groups on the Azure virtual machines if the primary site fails.
            Which four actions should you perform in sequence in the Azure infrastructure? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
            70-473 dumps exhibit

              Answer:

              Explanation: 70-473 dumps exhibit

              NEW QUESTION 16
              You need to implement the monitoring solution for the Listings database.
              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.
              70-473 dumps exhibit

                Answer:

                Explanation: 70-473 dumps exhibit

                NEW QUESTION 17
                You plan to deploy a Microsoft Azure SQL database named DB1 to support a new application named Appl. You need to recommend a solution for DB1 that meets the following requirements if a single region fails:
                • DB1 must remain available.
                • App1 must reconnect automatically.
                What should you recommend implementing to meet each requirement? To answer, select the appropriate options in the answer area.
                NOTE: Each correct selection is worth one point.
                70-473 dumps exhibit

                  Answer:

                  Explanation: References:
                  https://docs.microsoft.com/en-us/azure/sql-database/sql-database-geo-replication-overview

                  NEW QUESTION 18
                  You are evaluating the migration of the databases from Host1 and WebData1 to Azure.
                  You need to recommend the most cost-effective solution for storing the database in Azure. The solution must meet the business requirements.
                  In the table below, recommend the most cost-effective storage solution for Host1 and WebData1. NOTE: Make only one selection in each column.
                  70-473 dumps exhibit

                    Answer:

                    Explanation: 70-473 dumps exhibit

                    Thanks for reading the newest 70-473 exam dumps! We recommend you to try the PREMIUM Certleader 70-473 dumps in VCE and PDF here: https://www.certleader.com/70-473-dumps.html (136 Q&As Dumps)