[2018-3-16] Lead2pass Microsoft 70-764 Latest Exam Dumps Download (161-170)

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

https://www.lead2pass.com/70-764.html ^{11 1}

QUESTION 161
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 data warehouse that stored sales data. One fact table has 100 million rows.

You must reduce storage needs for the data warehouse.

You need to implement a solution that uses column-based storage and provides real-time analytics for the operational workload.

Solution: You remove all clustered indexes, sort the transactions in the table, and create a clustered index on the table, so that the table is not a heap.

Does the solution meet the goal?

A.    Yes
B.    No

Answer: A
Explanation:
Columnstore indexes are the standard for storing and querying large data warehousing fact tables. It uses column-based data storage and query processing to achieve up to 10x query performance gains in your data warehouse over traditional row-oriented storage, and up to 10x data compression over the uncompressed data size.
In SQL Server, rowstore refers to table where the underlying data storage format is a heap, a clustered index, or a memory-optimized table.
References: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview ^{3 2}

QUESTION 162
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 data warehouse that stored sales data. One fact table has 100 million rows.

You must reduce storage needs for the data warehouse.

You need to implement a solution that uses column-based storage and provides real-time analytics for the operational workload.

Solution: You load the data in a heap table.

Does the solution meet the goal?

A.    Yes
B.    No

Answer: B
Explanation:
It is better to use a clustered index.
Columnstore indexes are the standard for storing and querying large data warehousing fact tables. It uses column-based data storage and query processing to achieve up to 10x query performance gains in your data warehouse over traditional row-oriented storage, and up to 10x data compression over the uncompressed data size.
In SQL Server, rowstore refers to table where the underlying data storage format is a heap, a clustered index, or a memory-optimized table.
References: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview ^{3 2}

QUESTION 163
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 data warehouse that stored sales data. One fact table has 100 million rows.

You must reduce storage needs for the data warehouse.

You need to implement a solution that uses column-based storage and provides real-time analytics for the operational workload.

Solution: You generate a new certificate on new instance.

Does the solution meet the goal?

A.    Yes
B.    No

Answer: B
Explanation:
Certificates are of no use in this scenario.

QUESTION 164
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 attempt to restore a database on a new SQL Server instance and receive the following error message:

"Msg 33111, Level 16, State 3, Line 2
Cannot find server certificate with thumbprint
`0x7315277C70764B1F252DC7A5101F6F66EFB1069D."

You need to ensure that you can restore the database successfully.

Solution: You add the backup set password to the restore command.
Does this meet the goal?

A.    Yes
B.    No

Answer: B
Explanation:
The error is related to the certificate.
References: https://dba.stackexchange.com/questions/3388/restore-encrypted-database-to-another-server?rq=1 ^{5 4}

QUESTION 165
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 attempt to restore a database on a new SQL Server instance and receive the following error message:

"Msg 33111, Level 16, State 3, Line 2
Cannot find server certificate with thumbprint
`0x7315277C70764B1F252DC7A5101F6F66EFB1069D."

You need to ensure that you can restore the database successfully.

Solution: You restore the certificate on the new instance.

Does this meet the goal?

A.    Yes
B.    No

Answer: A
Explanation:
The error is related to the certificate.
References: https://dba.stackexchange.com/questions/3388/restore-encrypted-database-to-another-server?rq=1 ^{5 4}

QUESTION 166
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 database that includes a table named Candidate.

You need to update the statistics for a column named Skills in the table and turn off automatic statistics updates for the column.

Solution: You run the following query:

Does this meet the goal?

A.    Yes
B.    No

Answer: A
Explanation:
FULLSCAN: Compute statistics by scanning all rows in the table or indexed view. FULLSCAN and SAMPLE 100 PERCENT have the same results.
References: https://technet.microsoft.com/en-us/library/ms187348(v=sql.110).aspx ⁶

QUESTION 167
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 database that includes a table named Candidate.

You need to update the statistics for a column named Skills in the table and turn off automatic statistics updates for the column.

Solution: You run the following query:

Does this meet the goal?

A.    Yes
B.    No

Answer: A
Explanation:
The following example updates the Products statistics in the Product table, forces a full scan of all rows in the Product table, and turns off automatic statistics for the Products statistics.
USE AdventureWorks2012;
GO
UPDATE STATISTICS Production.Product(Products)
WITH FULLSCAN, NORECOMPUTE;
Note: NORECOMPUTE
Disable the automatic statistics update option, AUTO_UPDATE_STATISTICS, for the specified statistics. If this option is specified, the query optimizer completes this statistics update and disables future updates.
To re-enable the AUTO_UPDATE_STATISTICS option behavior, run UPDATE STATISTICS again without the NORECOMPUTE option or run sp_autostats.
References: https://docs.microsoft.com/en-us/sql/t-sql/statements/update-statistics-transact-sql ^{8 7}

QUESTION 168
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 database that includes a table named Candidate.

You need to update the statistics for a column named Skills in the table and turn off automatic statistics updates for the column.

Solution: You run the following query:

Does this meet the goal?

A.    Yes
B.    No

Answer: B
Explanation:
RESAMPLE: Update each statistic using its most recent sample rate.
References: https://docs.microsoft.com/en-us/sql/t-sql/statements/update-statistics-transact-sql ^{8 7}

QUESTION 169
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 Audit 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 SERVER STATE permission to User1.

Does this meet the goal?

A.    Yes
B.    No

Answer: A
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 ^{10 9}

QUESTION 170
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 assign the db_datareader role 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 ^{10 9}

70-764 dumps full version (PDF&VCE): https://www.lead2pass.com/70-764.html ^{11 1}

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 ¹⁷

1. https://www.lead2pass.com/70-764.html
2. https://docs.microsoft.com/en-us/sql/relational-da tabases/indexes/columnstore-indexes-overview
3. https://docs.microsoft.com/en-us/sql/relational-da tabases/indexes/columnstore-indexes-overview
4. https://dba.stackexchange.com/questions/3388/resto re-encrypted-database-to-another-server?rq=1
5. https://dba.stackexchange.com/questions/3388/resto re-encrypted-database-to-another-server?rq=1
6. https://technet.microsoft.com/en-us/library/ms1873 48(v=sql.110).aspx
7. https://docs.microsoft.com/en-us/sql/t-sql/stateme nts/update-statistics-transact-sql
8. https://docs.microsoft.com/en-us/sql/t-sql/stateme nts/update-statistics-transact-sql
9. https://technet.microsoft.com/en-us/library/cc2806 65(v=sql.105).aspx
10. https://technet.microsoft.com/en-us/library/cc2806 65(v=sql.105).aspx
11. https://www.lead2pass.com/70-764.html
12. https://drive.google.com/open?id=0B3Syig5i8gpDUjBo M0pVQnlUTlU
13. https://drive.google.com/open?id=0B3Syig5i8gpDU2RS QnhzX2pIZVE
14. https://drive.google.com/open?id=0B3Syig5i8gpDMW9N cjJrQXlsMGs
15. https://drive.google.com/open?id=0B3Syig5i8gpDejcz eWp0aURaSnM
16. https://drive.google.com/open?id=0B3Syig5i8gpDdTF0 R0taLWgxSmc
17. https://drive.google.com/open?id=0B3Syig5i8gpDZ2pR QkV6Vnc4dHc