Microsoft 70-765 Study Guides 2021

Master the content and be ready for exam day success quickly with this . We guarantee it!We make it a reality and give you real in our Microsoft 70-765 braindumps. Latest 100% VALID at below page. You can use our Microsoft 70-765 braindumps and pass your exam.

Free 70-765 Demo Online For Microsoft Certifitcation:

NEW QUESTION 1
A company has an on-premises Microsoft SQL Server 2021 infrastructure. The storage area network (SAN) that supports the SQL infrastructure has reached maximum capacity.
You need to recommend a solution to reduce on-premises storage use without changing the application. What should you do?

  • A. Configure an Express Route connection to Microsoft Azure.
  • B. Configure a Microsoft Azure Key Vault.
  • C. Configure geo-replication on the SAN.
  • D. Configure SQL Server Stretch Database in Microsoft Azure.

Answer: D

Explanation: Stretch warm and cold transactional data dynamically from SQL Server to Microsoft Azure with SQL Server Stretch Database. Unlike typical cold data storage, your data is always online and available to query. Benefit from the low cost of Azure rather than scaling expensive, on-premises storage.
References:
https://docs.microsoft.com/en-us/sql/sql-server/stretch-database/stretch-database?view=sql-server-2021

NEW QUESTION 2
You administer a Microsoft SQL Server 2014 database named Contoso on a server named Server01.
You need to write messages to the Application Log when users are added to or removed from a fixed server
role in Server01.
What should you create?

  • A. A Database Audit Specification
  • B. A Policy
  • C. An Alert
  • D. A SQL Profiler Trace
  • E. A Resource Pool
  • F. An Extended Event session
  • G. A Server Audit Specification

Answer: G

Explanation: The SQL Server Audit feature enables you to audit server-level and database-level groups of events and individual events.
Audits can have the following categories of actions:
Server-level. These actions include server operations, such as management changes, such as in this question, and logon and logoff operations.
Database-level. These actions encompass data manipulation languages (DML) and data definition language (DDL) operations.
Audit-level. These actions include actions in the auditing process.
References:
http://technet.microsoft.com/en-us/library/cc280663(v=sql.105).aspx

NEW QUESTION 3
You have Microsoft SQL Server on a Microsoft Azure Virtual machine that has a 4-TB database.
You plan to configure daily backups for the database. A single full backup will be approximately 1.5 TB of compressed data.
You need to ensure that the last backups are retained. Where should you store the daily backups?

  • A. Local storage
  • B. Page blob storage
  • C. Virtual disks
  • D. Block blob storage.

Answer: D

Explanation: When backing up to Microsoft Azure blob storage, SQL Server 2021 supports backing up to multiple blobs to enable backing up large databases, up to a maximum of 12.8 TB. This is done through Block Blobs.
References:

NEW QUESTION 4
You plan to deploy a Microsoft SQL Server database that will use FILESTREAM. The database will store 4 TB of FILESTREAM data on a single Windows partition.
You need to configure the hard disk that will support the FILESTREAM data. The solution must provide the fastest read and write access to the data.
How should you configure the disk? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
70-765 dumps exhibit

    Answer:

    Explanation: File System: NTFS
    8.3 filename support: Disabled Indexing: Disabled
    NTFS is required.
    Disable generation of 8.3 names on all NTFS volumes used for FILESTREAM data storage.
    Check that search indexing is not enabled on FILESTREAM volumes, under the Volume Properties window, unchecking the “Allow files on this drive to have contents indexed in addition to file properties” box.
    References:
    https://blogs.msdn.microsoft.com/blogdoezequiel/2011/02/11/best-practices-on-filestreamimplementations/

    NEW QUESTION 5
    You have Microsoft SQL Server on a Microsoft Azure virtual machine. The virtual machine has a database named DB1. DB1 contains a table named Table1 that has 4 billion rows.
    Users report that a query using Table1 takes longer than expected to execute.
    You review the execution plan for the query and discover that the expected number of returned rows is one, while the actual number of returned rows is 1 million.
    You need to reduce the amount of time it takes for the query to execute. The solution must prevent additional performance issues from being introduced.
    Hot Area:
    70-765 dumps exhibit

      Answer:

      Explanation: When you set the AUTO_CREATE_STATISTICS option on, the Query Optimizer creates statistics on individual columns used in a predicate, if these statistics are not already available. These statistics are necessary to generate the query plan.
      References:
      https://www.mssqltips.com/sqlservertip/2766/sql-server-auto-update-and-auto-create-statisticsoptions/

      NEW QUESTION 6
      Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
      After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
      You have Microsoft SQL Server on a Microsoft Azure virtual machine that has a database named DB1. You discover that DB1 experiences WRITE_LOG waits that are longer than 50 ms.
      You need to reduce the WRITE_LOG wait time. Solution: Add additional data files to DB1. Does this meet the goal?

      • A. Yes
      • B. No

      Answer: B

      Explanation: In SQL Server, if we have a transactional based system and find a high WRITELOG wait type this is a performance bottleneck and can cause the transaction log file to grow rapidly and frequently.
      It is being recommended to SQL server users that they must archive the log files on a separate disk for getting better performance.
      References: https://atdhebuja.wordpress.com/2021/06/20/resolving-sql-server-transaction-log-waits/

      NEW QUESTION 7
      A company has an on-premises Microsoft SQL Server 2021 environment. All futures databases must meet the following requirements:
      The recovery model must be set to simple.
      The compatibility level must be set to SQL server 2014 (120).
      Your need to configure the SQL server 2021 environment.
      In the table below, identify the database you must modify for each requirement.
      70-765 dumps exhibit

        Answer:

        Explanation: Model: Change from full to simple Recovery Model
        Newly created user databases use the same recovery model as the model database.
        The model database is used as the template for all databases created on an instance of SQL Server. Because tempdb is created every time SQL Server is started, the model database must always exist on a SQL Server system. The entire contents of the model database, including database options, are copied to the new database.
        Model: Set compatibility level to 120
        For all installations of SQL Server, the default compatibility level is set to the version of the Database Engine. Databases are set to this level unless the model database has a lower compatibility level.
        References:
        https://docs.microsoft.com/en-us/sql/relational-databases/databases/model-database?view=sql-server-2021 https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level?view=sql-se

        NEW QUESTION 8
        You plan to install Microsoft SQL Server 2014 for a web hosting company.
        The company plans to host multiple web sites, each supported by a SQL Server database.
        You need to select an edition of SQL Server that features backup compression of databases, basic data integration features, and low total cost of ownership.
        Which edition should you choose?

        • A. Express Edition with Tools
        • B. Standard Edition
        • C. Web Edition
        • D. Express Edition with Advanced Services

        Answer: B

        NEW QUESTION 9
        You plan to migrate a Microsoft SQL server instance between physical servers. You must migrate the metadata associated with the database instance.
        You need to ensure that the new instance retains the existing jobs and alerts. Solutions: You restore the service master key.
        Does the solution meet the goal?

        • A. Yes
        • B. No

        Answer: B

        Explanation: The Service Master Key is the root of the SQL Server encryption hierarchy. It does not handle alerts and jobs. The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as
        SQL Server Management Studio, Service Broker and Database Mail.
        References:
        https://docs.microsoft.com/en-us/sql/relational-databases/databases/msdb-database?view=sql-server-2021

        NEW QUESTION 10
        You create a new Microsoft Azure subscription.
        You need to create a group of Azure SQL databases that share resources. Which cmdlet should you run first?

        • A. New-AzureRmAvailabilitySet
        • B. New-AzureRmLoadBalancer
        • C. New-AzureRmSqlDatabaseSecondary
        • D. New-AzureRmSqlElasticPool
        • E. New-AzureRmVM
        • F. New-AzureRmSqlServer
        • G. New-AzureRmSqlDatabaseCopy
        • H. New-AzureRmSqlServerCommunicationLink

        Answer: D

        Explanation: SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single Azure SQL Database server and share a set number of resources (elastic Database Transaction Units (eDTUs)) at a set price. Elastic pools in Azure SQL Database enable SaaS developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database.
        References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

        NEW QUESTION 11
        Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets stated goals.
        Your company plans to use Microsoft Azure Resource Manager templates for all future deployments of SQL Server on Azure virtual machines.
        You need to create the templates.
        Solution: You create the desired SQL Server configuration in an Azure Resource Group, then export the Resource Group template and save it to the Templates Library.
        Does the solution meet the goal?

        • A. Yes
        • B. No

        Answer: B

        Explanation: Azure Resource Manager template consists of JSON, and expressions that you can use to construct values for your deployment.
        A good JSON editor, not a Resource Group template, can simplify the task of creating templates.
        Note: In its simplest structure, a Azure Resource Manager template contains the following elements:
        {
        "$schema": "http://schema.management.azure.com/schemas/2015-01- 01/deploymentTemplate.json#",
        "contentVersion": "", "parameters": { },
        "variables": { },
        "resources": [ ],
        "outputs": { }
        }
        References:https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-authoring-templates

        NEW QUESTION 12
        You are using dynamic management views to monitor an SQL Server server named SQL1. A database administrator named Dba1 must monitor the health of SQL1.
        You need to ensure that Dba1 can access dynamic management views for SQL1. The solution must use the principle of least privilege.
        Which permissions should you assign to Dba1?

        • A. VIEW ANY DEFINITION
        • B. VIEW SERVER STATE
        • C. VIEW DEFINITION
        • D. CONTROL SERVER

        Answer: B

        Explanation: To query a dynamic management view or function requires SELECT permission on object and VIEW SERVER STATE or VIEW DATABASE STATE permission.
        There are two types of dynamic management views and functions:
        Server-scoped dynamic management views and functions. These require VIEW SERVER STATE permission on the server.
        Database-scoped dynamic management views and functions. These require VIEW DATABASE STATE permission on the database.
        References:
        https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/system-dynamic-

        NEW QUESTION 13
        DRAG DROP
        A new Azure Active Directory security principal named ReportUser@contoso.onmicrosoft.com should have access to select all current and future objects in the Reporting database. You should not grant the principal any other
        permissions. You should use your Active Directory Domain Services (AD DS) account to authenticate to the Azure SQL database.
        You need to create the new security principal.
        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-765 dumps exhibit

          Answer:

          Explanation: Step 1:
          To provision an Azure AD-based contained database user (other than the server administrator that owns the database), connect to the database (here the Reporting database) with an Azure AD identity (not with a SQL Server account) that has access to the database.
          Step 2: CREATE USER ... FROM EXTERNAL PROVIDER
          To create an Azure AD-based contained database user (other than the server administrator that owns the database), connect to the database with an Azure AD identity, as a user with at least the ALTER ANY USER permission. Then use the following Transact-SQL syntax:
          CREATE USER <Azure_AD_principal_name> FROM EXTERNAL PROVIDER;
          Step 3:
          Grant the proper reading permissions.
          References:https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad- authentication

          NEW QUESTION 14
          Settings Value VM size D3
          Storage Location Drive E Storage type Standard Tempdb location Drive C
          The workload on this instance has of the tembdb load.
          You need to maximize the performance of the tempdb database.
          Solution: You use a GS- Series VM and store the tempdb database on attached Premium storage. Does this meet the goal?

          • A. Yes
          • B. No

          Answer: B

          Explanation: For VMs that support Premium Storage (DS-series, DSv2-series, and GS-series), we recommend storing TempDB on a disk that supports Premium Storage with read caching enabled. There is one exception to this recommendation; if your TempDB usage is write-intensive, you can achieve higher performance by storing TempDB on the local D drive, which is also SSD-based on these machine sizes.
          References:
          https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performan

          NEW QUESTION 15
          HOTSPOT
          You need to create the contosodb1 database.
          How should you complete the Azure PowerShell command? To answer, select the appropriate Azure PowerShell segments in the answer area.
          70-765 dumps exhibit

            Answer:

            Explanation: Box 1: New-AzureRmSqlDatabase
            New-AzureRmSqlDatabase creates a database or an elastic database.
            New-AzureRmSqlDatabase is a command with the Azure Resource Manager (AzureRM) module.Azure Resource Manager enables you to work with the resources in your solution as a group.

            NEW QUESTION 16
            You administer a Microsoft SQL Server 2014 database. The database is currently configured to log ship to a secondary server.
            You are preparing to cut over to the secondary server by stopping log-shipping and bringing the secondary database online. You want to perform a tail-log backup.
            You need to leave the primary database in a restoring state.
            Which option of the BACKUP LOG command should you use?

            • A. NO_TRUNCATE
            • B. NORECOVERY
            • C. STANDBY
            • D. FORMAT

            Answer: B

            Explanation: It is recommended that you take a tail-log backup in the following scenarios:
            * If the database is online and you plan to perform a restore operation on the database, begin by backing up the tail of the log. To avoid an error for an online database, you must use the … WITH NORECOVERY option of the BACKUP Transact-SQL statement.
            Note: A tail-log backup captures any log records that have not yet been backed up (the tail of the log) to prevent work loss and to keep the log chain intact. Before you can recover a SQL Server database to its latest point in time, you must back up the tail of its transaction log. The tail-log backup will be the last backup of interest in the recovery plan for the database.
            References:
            https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/tail-log-backups-sql-server

            NEW QUESTION 17
            You deploy a new Microsoft Azure SQL database instance to support a variety of mobile application and public websites. You configure geo-replication with regions in Brazil and Japan.
            You need to implement real-time encryption of the database and all backups.
            Solution: You use the always Encrypted wizard to encrypt all possible for the tables in the primary instance. Does the solution meet the goal?

            • A. Yes
            • B. No

            Answer: B

            Explanation: Always Encrypted does not support geo replication. Transparent Data Encryption (TDE) would provide a solution.
            Note: Use the Always Encrypted Wizard to help protect sensitive data stored in a SQL Server database. Always Encrypted allows clients to encrypt sensitive data inside client applications and never reveal the encryption keys to SQL Server.
            References:
            https://azure.microsoft.com/en-us/blog/how-to-configure-azure-sql-database-geo-dr-with-azure-key-vault/
            http://blog.pragmaticworks.com/sql-server-2021-data-masking-and-always-encrypted

            NEW QUESTION 18
            You administer a Microsoft SQL Server 2014 server. The MSSQLSERVER service uses a domain account named CONTOSOSQLService.
            You plan to configure Instant File Initialization.
            You need to ensure that Data File Autogrow operations use Instant File Initialization. What should you do? Choose all that apply.

            • A. Restart the SQL Server Agent Service.
            • B. Disable snapshot isolation.
            • C. Restart the SQL Server Service.
            • D. Add the CONTOSOSQLService account to the Perform Volume Maintenance Tasks local security policy.
            • E. Add the CONTOSOSQLService account to the Server Operators fixed server role.
            • F. Enable snapshot isolation.

            Answer: CD

            Explanation: How To Enable Instant File Initialization References:
            http://msdn.microsoft.com/en-us/library/ms175935.aspx

            NEW QUESTION 19
            You use a Microsoft Azure SQL database as a data warehouse. The database is in the Standard service tier and has 400 elastic database throughput units (eDTUs).
            You load data to the database by using Azure Data Factory. You need to reduce the amount of time it takes to load the data.
            Solution: You move the database to a Standard database pool that has 800 eDTUs. Does the solution meet the goal?

            • A. Yes
            • B. No

            Answer: A

            Explanation: We need at least 400 eDTUs and the use of a Standard database pool.
            References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-dtu-resource-limits

            100% Valid and Newest Version 70-765 Questions & Answers shared by Certstest, Get Full Dumps HERE: https://www.certstest.com/dumps/70-765/ (New 209 Q&As)