web analytics

[2018-3-16] Lead2pass 2018 100% Real 70-764 Exam Questions (171-180)

Lead2pass 2018 New Microsoft 70-764 Braindump Free Download.v.2018-3-16.332q:

https://www.lead2pass.com/70-764.html

QUESTION 171
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 a server named Server1 that has Microsoft SQL Server installed.

Server1 has SQL Server Adult configured to send audit even records to a file.

You need to ensure that a database user named User1 can review the audit data.

Solution: You grant the VIEW ANY DEFINITION permission to User1.

Does this meet the goal?

A.    Yes
B.    No

Answer: B
Explanation:
Each feature and command for SQL Server Audit has individual permission requirements.
Unless otherwise specified, viewing catalog views requires a principal to have one of the following:
The VIEW SERVER STATE permission.
The VIEW AUDIT STATE permission (gives only the principal access to the sys.server_audits catalog view).
Membership in the sysadmin fixed server role.
The CONTROL SERVER permission.
The ALTER ANY AUDIT permission.
A principal must have the VIEW SERVER STATE or ALTER ANY AUDIT permission to use the Dynamic Management Views.
References: https://technet.microsoft.com/en-us/library/cc280665(v=sql.105).aspx

QUESTION 172
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 a Microsoft Azure SQL database that has Blob Auditing configured.

You need to review the audit logs.

Solution: You download the log files by using Microsoft Azure Storage Explorer, and then you open the files by using Microsoft SQL Server Management Studio (SSMS).

Does this meet the goal?

A.    Yes
B.    No

Answer: A
Explanation:
There are several methods you can use to view blob auditing logs:
After downloading several files or a subfolder that contains log files, you can merge them locally by using Merge Audit Files in SQL Server Management Studio.
Use the Azure portal.
Use the system function sys.fn_get_audit_file (T-SQL) to return the audit log data in tabular format.
References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing

QUESTION 173
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 a Microsoft Azure SQL database that has Blob Auditing configured.

You need to review the audit logs.

Solution: From Microsoft SQL Server Management Studio, you connect to the database, and then you execute the following statement.

1731

Does this meet the goal?

A.    Yes
B.    No

Answer: B
Explanation:
The fn_get_audit_file, not dm_db_audit_file, the returns information from an audit file created by a server audit in SQL Server.
This example reads from a file that is named ShiraServer/MayaDB/SqlDbAuditing_Audit/2017-07-14/10_45_22_173_1.xel:
SELECT * FROM sys.fn_get_audit_file (‘https://mystorage.blob.core.windows.net/sqldbauditlogs/ShiraServer/MayaDB/SqlDbAuditing_Audit/2017-07-14/10_45_22_173_1.xel’,default,default); Note: Blob auditing logs are saved as a collection of blob files within a container named sqldbauditlogs.
References: https://docs.microsoft.com/en-us/sql/relational-databases/system-functions/sys-fn-get-audit-file-transact-sql

QUESTION 174
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 a Microsoft Azure SQL database that has Blob Auditing configured.

You need to review the audit logs.

Solution: From Microsoft SQL Server Management Studio, you connect to the database, and then you execute the following statement.

1741

Does this meet the goal?

A.    Yes
B.    No

Answer: B
Explanation:
The fn_get_audit_file, not dm_db_audit_file, the returns information from an audit file created by a server audit in SQL Server.
This example reads from a file that is named ShiraServer/MayaDB/SqlDbAuditing_Audit/2017-07-14/10_45_22_173_1.xel:
SELECT * FROM sys.fn_get_audit_file (‘https://mystorage.blob.core.windows.net/sqldbauditlogs/ShiraServer/MayaDB/SqlDbAuditing_Audit/2017-07-14/10_45_22_173_1.xel’,default,default); Note: Blob auditing logs are saved as a collection of blob files within a container named sqldbauditlogs.
References: https://docs.microsoft.com/en-us/sql/relational-databases/system-functions/sys-fn-get-audit-file-transact-sql

QUESTION 175
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

You maintain a Microsoft SQL Server instance that contains the following databases SalesDb1, SalesDb2, and SalesDb3. Each database has tabled named Products and Sales. The following table shows the configuration of each database.

1751

The backup strategies for each database are described in the following table.
1752

Each full or differential backup operation writes into a new file and uses a different sequence number. You observe the following database corruption issues.

1753

SalesDb3 reports a number of database corruption issues related to error 823 and 824 when reading data pages. You must display the following information about the corrupted pages:

– database name
– impacted file id
– impacted file physical name
– impacted page id
– event type that identifies the error type
– error count

Users report performance issues when they run queries against SalesDb2. You plan to monitor query statistics and execution plans for SalesDb2 by using Query Store. The monitoring strategy must meet the following requirements:

– Perform automatic data cleanup when query store disk usage reaches 500 megabyte (MB).
– Capture queries based on resource consumption.
– Use a stale query threshold value of 60 days.

The query optimizer generates suboptimal execution plans for a number of queries on the Sales table in SalesDb2. You will create a maintenance plan that updates statistics for the table. The plan should only update statistics that were automatically created and have not been updated for 30 days. The update should be based on all data in the table.

You need to view the information about the corrupted pages on SalesDb3.

How should you complete the Transact-SQL statement?

Select two.

A.    SELECT * FROM msdb.. corrupted_pages
B.    SELECT * FROM msdb..suspect_pages
C.    SELECT * FROM system..corrupted_pages
D.    SELECT * FROM system..suspect_pages
E.    WHERE event_type = 1
F.    WHERE event_type = 2
G.    WHERE event_type = 3

Answer: BF
Explanation:
suspect_pages contains one row per page that failed with a minor 823 error or an 824 error. Pages are listed in this table because they are suspected of being bad, but they might actually be fine. When a suspect page is repaired, its status is updated in the event_type column.
The suspect_pages table resides in the msdb database.
SalesDb3 has pages with checksum errors. Checksum errors have the event_type value 2.
References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/manage-the-suspect-pages-table-sql-server

QUESTION 176
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

A company has offices in Vancouver, Tokyo, and Paris. The company uses Microsoft SQL Server 2016 Standard edition. You must design a reporting solution that uses data from a point of sale (POS) application’s transactional database.

After data is entered into the POS system, users must be able to run reports within 24 hours. Latency must be minimized.

You need to implemented a solution that minimizes licensing costs.

What should you implement?

A.    a Microsoft Azure Stretch Database
B.    log shipping
C.    an Always On Availability Group with all replicas in synchronous-commit mode
D.    a file share witness
E.    a Microsoft SQL Server failover cluster instance (FCI)
F.    a Windows cluster with a shared-nothing architecture
G.    an Always On Availability Group with secondary replicas in asynchronous-commit mode

Answer: A
Explanation:
Stretch Database targets transactional databases with large amounts of cold data, typically stored in a small number of tables. These tables may contain more than a billion rows.
Stretch Database provides the following benefits:
Provides cost-effective availability for cold data
Doesn’t require changes to queries or applications
Streamlines on-premises data maintenance
Keeps your data secure even during migration
References: https://docs.microsoft.com/en-us/sql/sql-server/stretch-database/stretch-database

QUESTION 177
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

You need to deploy a new Microsoft SQL Server environment that meets the following requirements:

– The SQL Server instance must be highly available.
– There must be minimal downtime incurred during hardware failure or operating system maintenance.
– All instance-level security settings and SQL Server Agent jobs must be available without additional synchronization tasks.

What should you implement?

A.    a Microsoft Azure Stretch Database
B.    log shipping
C.    an Always On Availability Group with all replicas in synchronous-commit mode
D.    a file share witness
E.    a Microsoft SQL Server failover cluster instance (FCI)
F.    a Windows cluster with a shared-nothing architecture
G.    an Always On Availability Group with secondary replicas in asynchronous-commit mode

Answer: E
Explanation:
As part of the SQL Server Always On offering, Always On Failover Cluster Instances leverages Windows Server Failover Clustering (WSFC) functionality to provide local high availability through redundancy at the server-instance level–a failover cluster instance (FCI). An FCI is a single instance of SQL Server that is installed across Windows Server Failover Clustering (WSFC) nodes and, possibly, across multiple subnets.
When there is hardware or software failure of a server, the applications or clients connecting to the server will experience downtime. When a SQL Server instance is configured to be an FCI (instead of a standalone instance), the high availability of that SQL Server instance is protected by the presence of redundant nodes in the FCI.
References: https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/always-on-failover-cluster-instances-sql-server

QUESTION 178
You have a database named DB1.

Users report that a database application that updates the data in DB1 is unresponsive.

You need to identify which process prevents the application from responding.

What should you do?

A.    Run DBCC INPUTBUFFER.
B.    Query sys.dm_exec_session_wait_stats.
C.    Run sp_autostats.
D.    Run sp_who.

Answer: B
Explanation:
Sys.dm_exec_session_wait_stats returns information about all the waits encountered by threads that executed for each session.
You can use this view to diagnose performance issues with the SQL Server session and also with specific queries and batches.
References: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-session-wait-stats-transact-sql

QUESTION 179
You have 10 Microsoft SQL Server 2016 servers.

You deploy a management data warehouse named DW1. You configure DW1 to gather all the performance data from the servers.

You configure a Data Collector on a SQL server named SV1.

You query the data warehouse on DW1 and discover that data from SV1 is unavailable.

You need to ensure that you can review the performance data from SV1 when you query DW1.

What should you do?

A.    Start the SQL Server Agent service on DW1.
B.    Execute the msdb.sp_syscollector_set_warehouse_connection_user stored procedure on SV1.
C.    Execute the msdb.sp_syscollector_enable_collector stored procedure on DW1.
D.    Start the SQL Server Agent service on SV1.

Answer: C
Explanation:
sp_syscollector_enable_collector enables the data collector.
References: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-syscollector-enable-collector-transact-sql

QUESTION 180
You manage a Microsoft SQL Server environment. You plan to configure Database Mail.

You need to ensure that all users can access a private Database Mail profile.

What should you do?

A.    On the tempdb database, add the DatabaseMailUserRole to userid 0.
B.    On the msdb database, add the DatabaseMailUserRole to the public user.
C.    On the master database, add the DatabaseMailUserRole to the public user.
D.    On the profile, grant access to the public user.

Answer: B
Explanation:
For each private profile, Database Mail maintains a list of users that are permitted to send e-mail using that profile. Public profiles are available to users or roles in the msdb database who are also members of the DatabaseMailUserRole.
By default, a profile is private, and no users are granted access to the profile. To make the profile public, grant access to the user ‘public’ or the user id 0.
Note: Profiles are either public or private. A private profile is accessible only to specific users or roles. A public profile allows any user or role with access to the mail host database (msdb) to send e-mail using that profile.
References: https://technet.microsoft.com/en-us/library/ms189879(v=sql.105).aspx

70-764 dumps full version (PDF&VCE): https://www.lead2pass.com/70-764.html

Large amount of free 70-764 exam questions on Google Drive: https://drive.google.com/open?id=0B3Syig5i8gpDUjBoM0pVQnlUTlU

You may also need:

70-761 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDU2RSQnhzX2pIZVE

70-762 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDMW9NcjJrQXlsMGs

70-765 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDejczeWp0aURaSnM

70-767 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDdTF0R0taLWgxSmc

70-768 exam dumps: https://drive.google.com/open?id=0B3Syig5i8gpDZ2pRQkV6Vnc4dHc