[2020.9] latest collection of Microsoft Certified Solutions Associate Practice question and answers

The most popular Microsoft Certified Solutions Associate Practice question and tips. (Microsoft 70-761 exam, Microsoft 70-764 exam, Microsoft 70-767 exam, Microsoft 70-768 exam) Exampdfdownload shares the latest exam Practice question and answers for free.
The latest popular Microsoft exam certification pass method:
https://www.leads4pass.com/mcsa.html High pass rate! Cost-effective!

Table of Contents:

Popular Microsoft 70-761 List

Exam 70-761: Querying Data with Transact-SQL: https://docs.microsoft.com/en-us/learn/certifications/exams/70-761

This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience who are seeking to validate their skills and knowledge in writing queries.

Skills measured

  • Manage data with Transact-SQL (40-45%)
  • Query data with advanced Transact-SQL components (30-35%)
  • Program databases by using Transact-SQL (25-30%)

[2020.9] Popular Microsoft 70-761 exam practice questions(1-5)

QUESTION 1
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 section. You will NOT be able to return to it. As a result, these questions will not
appear on the review screen.
You have a table named Products that stores information about the products your company sells. The table has a column
named ListPrice that stores retail pricing information for products.
Some products are used only internally by the company. Records for these products are maintained in the Products
table for inventory purposes. The price for each of these products is $0.00. Customers are not permitted to order these
products.
You need to increase the list price for products that cost less than $100 by 10 percent. You must only increase pricing
for products that customers are permitted to order. Solution: You run the following Transact-SQL statement:

lead4pass 70-761 exam questions q1

Does the solution meet the goal?
A. Yes
B. No
Correct Answer: B
Products with a price of $0.00 would also be increased.

QUESTION 2
You have a database named mydb. You run the following Transact-SQL statements:

lead4pass 70-761 exam questions q2

A value of 1 in the IsActive column indicates that a user is active.
You need to create a count for active users in each role. If a role has no active users, you must display a zero as the
active users count.
Which Transact-SQL statement should you run?

A. B. C. D.
Correct Answer: A

QUESTION 3
You run the following Transact-SQL statement:

lead4pass 70-761 exam questions q3

You use the table to store data about training courses: when they finished the location and the number of participants in
the courses.
You need to display a result set that shows aggregates for all possible combinations of the number of participants.
Which Transact-SQL statement should you run?
A. SELECT CourseID, CourseDate, SUM(NumParticipants) FROM CourseParticipants GROUP BY CourseID,
CourseDate
B. SELECT CourseID, CourseDate, SUM(DISTINCT NumParticipants) FROM CourseParticipants GROUP BY
CourseID, CourseDate
C. SELECT CourseID, CourseDate, SUM(NumParticipants) FROM CourseParticipants GROUP BY CourseID,
coursemate WITH CUBE
D. SELECT CourseID, CourseDate, SUM(DISTINCT NumParticipants) FROM CourseParticipants GROUP BY
CourseID, CourseDate WITH ROLLUP
Correct Answer: C
The WITH CUBE clause causes the query to compute all possible totals
References: https://blogs.msdn.microsoft.com/craigfr/2007/09/27/aggregation-with-cube/

QUESTION 4
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 section. You will NOT be able to return to it. As a result, these questions will not
appear on the review screen.
You create a table named Customer by running the following Transact-SQL statement:

lead4pass 70-761 exam questions q4

You need to ensure that both records are inserted or neither record is inserted. Solution: You run the following Transact-SQL statement:

lead4pass 70-761 exam questions q4-1

Does the solution meet the goal?
A. Yes
B. No
Correct Answer: B
As there is two separate INSERT INTO statements we cannot ensure that both or neither records are inserted.

QUESTION 5
DRAG DROP
You are a database administrator for an online retail store. You create a table to track orders by running the following
Transact-SQL statement:

lead4pass 70-761 exam questions q5

You need to create a report that includes the following information: Total sales for each year Total sales for each
category per year How should you complete the Transact-SQL statement? To answer,
drag the appropriate Transact-SQL segment to the correct locations. Each Transact-SQL segment may be used once,
more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each
correct selection is worth one point.
Select and Place:

lead4pass 70-761 exam questions q5-1

Correct Answer:

lead4pass 70-761 exam questions q5-2

Box 1: GROUP BY Box 2: CUBE GROUP BY CUBE creates groups for all possible combinations of columns. For
GROUP BY CUBE (a, b) the results have groups for unique values of (a, b), (NULL, b), (a NULL), and (NULL, NULL).
Example: This code runs a GROUP BY CUBE operation on Country and Region. SELECT Country, Region,
SUM(Sales) AS TotalSales FROM Sales GROUP BY CUBE (Country, Region); References:
https://docs.microsoft.com/en-us/sql/t-sql/queries/select-group-by-transact-sql

[PDF q1 – q13] Free Microsoft 70-761 pdf dumps download from Google Drive: https://drive.google.com/file/d/1KmtQt41gKewZVYt-66dIGxckHtsJOsJP/

Full Microsoft 70-761 brain dumps: https://www.leads4pass.com/70-761.html (Total Questions: 446 Q&A)

Popular Microsoft 70-764 List

Exam 70-764: Administering a SQL Database Infrastructure:https://docs.microsoft.com/en-us/learn/certifications/exams/70-764

This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

Skills measured

  • Configure data access and auditing (20-25%)
  • Manage backup and restore of databases (20-25%)
  • Manage and monitor SQL Server instances (35-40%)
  • Manage high availability and disaster recovery (20-25%)

[2020.9] Popular Microsoft 70-764 exam practice questions (1-4)

QUESTION 1
You work as a Database Administrator (DBA) for a company named ABC.com.
The company uses a Microsoft SQL Server 2012 infrastructure.
The sales and marketing departments contain a total of 60 users. Each user uses a custom application that stores data
in a SQL Server database.
Each user has a separate database.
A server named ABC-SQL1 hosts the 60 databases.
You need to configure a backup solution for all the databases.
The solution must ensure that any new databases configured on ABC-SQL1 are automatically added to the backup
schedule. The backup schedule consists of a full backup every night, a differential backup every hour and a transaction
log
backup every 15 minutes.
How should you configure the backup solution?
A. You should configure SQL Server Agent jobs.
B. You should configure Change Data Capture.
C. You should configure Policy-Based Management.
D. You should configure a Maintenance Plan.
Correct Answer: D

QUESTION 2
You administer a Microsoft SQL Server 2016 database that includes a table named Application. Events.
Application. Events contain millions of records about user activity in an application.
Records in Application. Events that are more than 90 days old are purged nightly.
When records are purged, table locks are causing contention with inserts.
You need to be able to modify the Application. Events without requiring any changes to the applications that utilize
Application.Events.
Which type of solution should you use?
A. Partitioned tables
B. Online index rebuild
C. Change data capture
D. Change tracking
Correct Answer: A

QUESTION 3
You manage a Microsoft SQL Server instance that has a database named DB1. The instance has a server audit named
Audit1. DB1 uses the following schemas:

lead4pass 70-764 exam questions q3

You need to implement a database audit specification for database DB1 that meets the following requirements:
Audit only delete statements performed by users in the db_datawriter role.
Audit insert statements for all tables in Schema1 for all users.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

lead4pass 70-764 exam questions q3-1

Correct Answer:

lead4pass 70-764 exam questions q3-2

QUESTION 4
You are designing a database named DB1.
Changes will be deployed to DB1 every Wednesday night.
You need to recommend a strategy to deploy the changes to DB1.
The strategy must meet the following requirements:
The strategy must not disrupt backup operations.
DB1 must be unavailable to users while the changes are deployed.
You must be able to undo quickly the entire operation.
What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.
A. Perform a copy-only database backup before the changes are deployed. If the deployment fails, restore the database
to another server and recover the original. Objects from the restored database.
B. Create a database snapshot. If the deployment fails, recover the objects from the database snapshot.
C. Create a database snapshot. If the deployment fails, revert the database to the database snapshot.
D. Perform a full database backup before the changes are deployed. If the deployment fails, restore the database to
another server and recover the original objects from the restored database.
Correct Answer: C

[PDF q1 – q13] Free Microsoft 70-764 pdf dumps download from Google Drive: https://drive.google.com/file/d/1jWffkOehAQthdtv03iWKlYzONK5QK-DV/

Full Microsoft 70-764 brain dumps: https://www.leads4pass.com/70-764.html (Total Questions: 445 Q&A)

Popular Microsoft 70-767 List

Exam 70-767: Implementing a Data Warehouse using SQL:https://docs.microsoft.com/en-us/learn/certifications/exams/70-767

This exam is intended for extract, transform, and load (ETL) and data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing, in addition to ETL and data warehouse implementation.

Skills measured

  • Design, implement and maintain a data warehouse (35-40%)
  • Extract, transform and load data (40-45%)
  • Build data quality solutions (15-20%)

[2020.9] Popular Microsoft 70-767 exam practice questions (1-5)

QUESTION 1
You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data
into a Windows Azure SQL Database database. The package has been deployed to a production server that runs
Windows
Server 2008 R2 and SQL Server 2016.
The package fails when executed on the production server.
You need to ensure that the package can load the Excel workbook data without errors. You need to use the least
amount of administrative effort to achieve this goal.
What should you do?
A. Install a 64-bit ACE driver and execute the package by using the 64-bit run-time option.
B. Enable Address Windowing Extensions (AWE) for the local SQL Server instance.
C. Replace the SSIS Excel source with an SSIS Flat File source.
D. Install a 64-bit ACE driver and replace the Excel source with an OLE DB source.
Correct Answer: D
Explanation: XLSX files, the new file type in Excel 2007/2010 cannot be opened with Excel Source/Destination in SSIS.
To use XLSX in SSIS we need to install the ACE driver and use OLE DB Source/Destination to read/write data in
XLSX
files.
ACE is a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft
Office Access (*.mdb and *.accdb) files and Microsoft Office Excel 7 (*.xls, *.xlsx, and *.xlsb) files to Microsoft SQL
Server.
If the SQL Server or your development box does not have an ACE driver then install that 1st.
Note:
*
The most efficient way to link to SQL Server is using an OLEDB connection manager.
Incorrect: Not B:
*
Address Windowing Extensions (AWE) is a Microsoft Windows application programming interface that allows a 32-bit
software application to access more physical memory than it has a virtual address space.
*
Address Windowing Extensions (AWE) is a set of extensions that allows an application to quickly manipulate physical
memory greater than 4GB. Certain data-intensive applications, such as database management systems and scientific
and engineering software, need access to very large caches of data. In the case of very large data sets, restricting the cache to fit within an application\\’s 2GB of user address space is a severe restriction. 

QUESTION 2
A company plans to load data from a CSV file that is stored in a Microsoft Azure Blob storage container.
You need to load the data.
How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQL segments to
the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to
drag
the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

lead4pass 70-767 exam questions q2

Correct Answer:

lead4pass 70-767 exam questions q2-1

QUESTION 3
You are installing SQL Server Data Quality Services (DQS).
You need to give specific users access to the Data Quality Server.
Which SQL Server application should you use?
A. SQL Server Configuration Manager
B. SQL Server Data Tools
C. SQL Server Management Studio
D. Data Quality Client
Correct Answer: C
Ref: http://msdn.microsoft.com/en-us/library/hh213045.aspx

QUESTION 4
The package uses data from the Products table and the Prices table. Properties of the Prices source are shown in the
OLE DB Source Editor exhibit (Click the Exhibit button.) and the Advanced Editor for Prices exhibit (Click the Exhibit
button.)

lead4pass 70-767 exam questions q4

You create a Microsoft SQL Server Integration Services (SSIS) package as shown in the SSIS Package exhibit. (Click
the Exhibit button.)

lead4pass 70-767 exam questions q4-1 lead4pass 70-767 exam questions q4-2

You join the Products and Prices tables by using the reference column.
You need to resolve the error with the package.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

lead4pass 70-767 exam questions q4-3

Correct Answer:

lead4pass 70-767 exam questions q4-4

There are two important sort properties that must be set for the source or upstream transformation that supplies data to
the Merge and Merge Join transformations:
The Merge Join Transformation requires sorted data for its inputs.
If you do not use a Sort transformation to sort the data, you must set these sort properties manually on the source or the upstream transformation.
References: https://docs.microsoft.com/en-us/sql/integration-services/dataflow/transformations/sort-data-for-the-mergeand-merge-join-transformations

QUESTION 5
You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy.
The package reads data from a source system that uses the SQL Server change data capture (CDC) feature.
You have added a CDC Source component to the data flow to read changed data from the source system.
You need to add a data flow transformation to redirect rows for separate processing of insert, update, and delete
operations.
Which data flow transformation should you use?
A. Audit
B. DQS Cleansing
C. CDC Splitter
D. Pivot
Correct Answer: C
Explanation: The CDC splitter splits a single flow of change rows from a CDC source data flow into different data flows
for Insert, Update and Delete operations Ref: http://msdn.microsoft.com/en-us/library/hh758656.aspx

[PDF q1 – q13] Free Microsoft 70-767 pdf dumps download from Google Drive: https://drive.google.com/file/d/1Dmk8rYFNy6NGkuZ36Cjv-ZZpERKyR9c3/

Full Microsoft 70-767 brain dumps: https://www.leads4pass.com/70-767.html (Total Questions: 402 Q&A)

Popular Microsoft 70-768 List

Exam 70-768: Developing SQL Data Models: https://docs.microsoft.com/en-us/learn/certifications/exams/70-768

This exam is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multidimensional data models, implementing and maintaining OLAP cubes, and implementing tabular data models.

Skills measured

  • Design a multidimensional business intelligence (BI) semantic model (25-30%)
  • Design a tabular BI semantic model (20-25%)
  • Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) (15-20%)
  • Configure and maintain SQL Server Analysis Services (SSAS) (30-35%)

[2020.9] Popular Microsoft 70-768 exam practice questions (1-5)

QUESTION 1
You are a business analyst for a company that uses a Microsoft SQL Server Analysis Services (SSAS) tabular database
for reporting. The database model contains the following tables:

lead4pass 70-768 exam questions q1

You have been asked to write a query for a report that returns the total sales for each product subcategory, as well as
for each product category.
You need to write the query to return the data for the report.
How should you complete the DAX statement? To answer, drag the appropriate DAX segment to the correct locations.
Each DAX segment may be used once, more than once, or not at all. You may need to drag the split bar between panes
or
scroll to view content.
Select and Place:

lead4pass 70-768 exam questions q1-1

Correct Answer:

lead4pass 70-768 exam questions q1-2

Box 1:EVALUATE
Box 2:SUMMERIZE
Box 3:ROLLUP
Box 4:\\’Product Subcategory\\’ [\\’Product Subcategory Name]
Note: The behavior of SUMMARIZE is similar to the GROUP BY syntax of a SELECT statement in SQL. For example,
consider the following query.
EVALUATE
SUMMARIZE(
\\’Internet Sales\\’,

\\’Internet Sales\\'[Order Date],
“Sales Amount”, SUM( \\’Internet Sales\\'[Sales Amount] )
)
This query calculates the total of Sales Amount for each date in which there is at least one
order,
producing this result.

QUESTION 2
You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used by the finance, sales, and
marketing teams.
The sales team reports that the model is too complex and difficult to use. The sales team does not need any information
other than sales related resources in the tabular model. The finance and marketing teams need to see all the resources
in the tabular model.
You need to implement a solution that meets the needs of the sales team while minimizing development and
administrative effort. What should you do?
A. Create a separate partition for each team.
B. Create a separate data source for each team.
C. Create a perspective for the sales team.
D. Enable client-side security to filter non-sales data.
Correct Answer: C

QUESTION 3
You need to create the cube processing job and the dimension processing job. Which processing task should you use
for each job? To answer, drag the appropriate processing tasks to the correct locations. Each processing task may be
used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:

lead4pass 70-768 exam questions q3

Box 1: ProcessData Processes data only without building aggregations or indexes. If there is data is in the partitions, it
will be dropped before re-populating the partition with source data. Box 2: Process Update Forces a re-read of data and
an update of dimension attributes. Flexible aggregations and indexes on related partitions will be dropped. References: https://docs.microsoft.com/en-us/sql/analysis-services/multidimensionalmodels/processing-options-and-settings-analysisservices

QUESTION 4
You install a SQL Server Analysis Services (SSAS) instance in tabular mode on a server.
While processing a very large tabular model, you receive an out-of-memory error. You identify that the amount of
physical memory in the server is insufficient. Additional physical memory cannot be installed on the server.
You need to configure the server to allow paging to disk by using the operating system page file (pagefile.sys).
Which four 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.)
Select and Place:

lead4pass 70-768 exam questions q4

Correct Answer:

lead4pass 70-768 exam questions q4-1

QUESTION 5
You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be used in the definition of a
hierarchy. The City column exists in the Geography table that is related to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?
A. City:= LOOKUP(Geography[City],Geography[GeographyKey],[GeographyKey])
B. City:= LOOKUPVALUE(Geography[City],Geography[GeographyKey],[GeographyKey]) C
.=RELATED(Geography[City])

C. =RELATED(Geography.City)
D. =VALUES(Geography[City])
E. City:=VALUES(Geography[City])
Correct Answer: C
Explanation: * RELATED Function Returns a related value from another table.

[PDF q1 – q13] Free Microsoft 70-768 pdf dumps download from Google Drive: https://drive.google.com/file/d/1E9l_hD7MEpxlMPJdB43uMpaCccvJt9uh/

Full Microsoft 70-768 brain dumps: https://www.leads4pass.com/70-768.html (Total Questions: 50 Q&A)

Lead4Pass Discount Code 2020

lead4pass coupon 2020

About Lead4pass Brand Advantage

Lead4pass employs the most authoritative exam specialists from Microsoft, Cisco, EMC, HP, CompTIA, etc. We update exam data throughout the year. Highest pass rate! We have a large user base. We are an industry leader!
Choose Lead4Pass to pass the exam with ease!

why lead4pass

Summarize:

It’s not easy to pass the exam, but with accurate learning materials and proper practice,
you can crack the exam with excellent results. https://www.leads4pass.com/mcsa.html provides you with the most relevant learning materials that you can use to help you prepare.

Ps.

keywords: Microsoft Certified Solutions Associate, 70-761 dumps, 70-761 exam questions, 70-761 exam dumps, 70-761 practice test, 70-761 study guide,70-764 study guide, 70-764 practice test, 70-764 dumps, 70-764 practice test free, 70-767 practice test, 70-767 exam preparation, 70-767 study guide, 70-767 dumps, 70-767 exam questions, 70-768 exam questions, 70-768 exam dumps, 70-768 dumps, 70-768 pdf, 70-768 exam preparation

latest updates to Microsoft MCSA 70-779 brain dump and practical and effective practice testing

How do I prepare for the Microsoft MCSA 70-779 exam?

Microsoft latest exam tips 2020! The Exampdfdownload provides the latest 70-779 exam Practice questions, 70-779 pdf,
70-779 exam dump to help you improve your skills! Improve the exam to pass!

Lea4pass is our partner and they have the most authoritative testing experts! Easily pass the exam,
select the complete Microsoft 70-779 exam dumps https://www.leads4pass.com/70-779.html The latest updated exam dump.
Guaranteed to be effective and authentic! Lead4Pass year-round updates ensure your first exam passes!

Exampdfdownload Exam Table of Contents:

Latest Microsoft 70-779 google drive

[PDF] Free Microsoft 70-779 pdf dumps download from Google Drive: https://drive.google.com/file/d/1eya9rudoHjL_pmpk1Z4LHiSSivpusD-d/

Latest updates Microsoft 70-779 exam practice questions

QUESTION 1
Start of repeated scenario
You are creating reports for a car repair company. You have four datasets in Excel spreadsheets. Four workbook
queries load the datasets to a data model. A sample of the data is shown in the Data Sample exhibit.

lead4pass 70-779 exam question q1

The data model is shown in the Data Model exhibit.

lead4pass 70-779 exam question q1-1

The tables in the model contain the following data:
DailyRepairs has a log of hours and revenue for each day, workshop, and repair type. Every day, a log entry is created
for each workshop, even if no hours or revenue are recorded for that day. Total Hours and Total Revenue are two
measures defined in DailyRepairs. Total Hours sums the Hours column, and Total Revenue sums the Revenue column.
Workshops have a list of all the workshops and the current and previous workshop managers. The format of the
Workshop Manager column is always Firstname Lastname, A value of 1 in the latest column indicates that the
workshop
The manager listed in the record is the current workshop manager.
Repair types have a list of all the repair types.
Dates have a list of all the repair types.
Dates have a list of dates from 2015to 2018.
End of repeated scenario.
You need to create a PivotChart that displays the month, the hours of the month, and the hours of the previous month,
as shown in the following exhibit.

lead4pass 70-779 exam question q1-2

Which DAX formula should you use for the Total Hours Last Month measure? To answer, drag the appropriate values to
the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar
between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

lead4pass 70-779 exam question q1-3

QUESTION 2

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 section, you will NOT be able to return to it. As a result, these questions will not
appear on the review screen.
You have two Microsoft SQL Server database servers named Production1 and Test1. Production1 contains the same
tables as Test1, but only a subset of the data.
You add Test1 as a data source, and you select 10 tables. You configure several transformations.
You need to connect the model to the tables in Production1. The solution must maintain the existing transformations.
Solution: From Query Editor, you edit the source of each table query.
Does this meet the goal?
A. Yes
B. No
Correct Answer: A

QUESTION 3
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 answers choices, but the text of the scenario is
the
same in each question in this series.
Start of repeated scenario
You have six workbook queries that each extracts a table from a Microsoft Azure SQL database. The tables are loaded
to the data model, but the data is not loaded to any worksheets. The data model is shown in the Data Model exhibit.

lead4pass 70-779 exam question q3

Your company has 100 product subcategories and more than 10,000 products.
End of repeated scenario.
You need to create a simplified view of the workbook for some users. The simplified view must only display data from
FactSales, DimProduct, and DimDate.
What should you do in the data model?
A. Click Hide from Client Tolls for all the tables except FactSales, DimProduct, and DimDate.
B. Create a new perspective.
C. Modify the Table Behavior settings for FactSales, DimProduct, and DimDate.
D. Add the columns from FactSales, DimProduct, and DimDate to the Default Field Set.
Correct Answer: A

QUESTION 4
You have a model that contains the following table named Sales.

lead4pass 70-779 exam question q4

You have a measure named TotalSales that calculates the sum of Line Total.
You plan to create a PivotChart to display TotalSale for each category and the percent of total sales for each category
as shown in the following exhibit.

lead4pass 70-779 exam question q4-1

How should you complete the DAX formula for the Percent measure? To answer, drag the appropriate values to the
correct targets. Each value may be used once, more than once, or not at all. You need to drag the split bar between
panes or

scroll to view content.
NOTE: Each correct selection is wroth on point.
Select and Place:

lead4pass 70-779 exam question q4-2

QUESTION 5
You have 12 sales reports stored in a folder as CSV files. Each report represents one month of sales data for a year.
The reports have the same structure.
You need to analyze the entire year of sales data.
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.
Select and Place:

lead4pass 70-779 exam question q5

QUESTION 6
You have a workbook query that gets data from a table in a Microsoft Azure SQL database. The table has a column
named Phone. The values in Phone are in a format of 999-999-9999. The first three digits of each phone number
represent
the area code and the rest of the digits represent the local phone number.
You need to split the Phone column into two columns. The first column must contain the area code and the second
the column must contain the local phone number.
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be
used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

lead4pass 70-779 exam question q6

QUESTION 7
You have a Power Pivot data model that contains a table named DimProduct DimProduct has seven columns named
ProductKey, ProductLabel, ProductName, ProductDescription, ProductSubCategoryKey, Manufacturer, and Brand.
Only the members of the product team use all the data in the DimProduct table.
You need to simplify the model for other users by hiding all the columns except ProductName.
What should you do?
A. Create a perspective that has only the ProductName field from DimProduct selected.
B. Select all the columns in DimProduct except ProductName, right-click the columns, and then click Hide from Client
Tools.
C. Edit the Default Field Set for DimProduct and add ProductName to the Default Field.
D. Edit the Table Behavior settings for DimProduct and add ProductName to the Default Label.

Correct Answer: B
https://support.office.com/en-us/article/hide-columns-and-tables-in-power-pivotddf5b1f2-2ed2-4bdb-8f78-6f94503ca87a

QUESTION 8
You install Microsoft Power BI Publisher for Excel.
You need to use Excel to connect and analyze Power BI data.
To which two types of Power BI data can you connect? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. apps
B. datasets
C. reports
D. dashboard
Correct Answer: BC
Analyze in Excel is very useful for datasets and reports that connect to Analysis Services Tabular or Multidimensional
databases, or from Power BI Desktop files or Excel workbooks with data models that have model measures created
using Data Analysis Expressions (DAX).
https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel

QUESTION 9
You have a workbook query that loads data from C:\Data\Users.xlsx.
You move Users.xlsx to a shared folder on the network.
You need to ensure that you can refresh the data from Users.xlsx.
What should you do?
A. From the Linked Table tab in Power Pivot, modify the Update Mode.
B. From Query Editor, modify the Source step.
C. From the Insert tab in Excel, click My Add-ins, and then manage the add-ins.
D. From the Data tab in Excel click Connections, and then modify the properties of the connection.
Correct Answer: A

QUESTION 10
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 section, you will NOT be able to return
to it. As a result, these questions will not appear in the review screen.
You have an Excel workbook that contains a table named Table1. A sample of the data in Table1 is shown in the
following table.

lead4pass 70-779 exam question q10

You need to create a PivotTable in PowerPivot as shown in the exhibit.

lead4pass 70-779 exam question q10-1

Solution: You create a measure named Products the uses the CONCATENATEX DAX function. You add a PivotTable.
You drag Products to the Rows field. You drag Price to the Values field. Does this meet the goal?
A. Yes
B. No
Correct Answer: B

QUESTION 11
You create a new workbook and add a table to a data model. The data is shown in the following table.

lead4pass 70-779 exam question q11

Witch 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.
Select and Place:

lead4pass 70-779 exam question q11-1

Correct Answer:

lead4pass 70-779 exam question q11-2

Create a Pivot Table.
Create a measure.
Create a Power View Report

QUESTION 12
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 section, you will NOT be able to return to it. As a result, these questions will not
appear on the review screen.
You have a Power Pivot model that contains the following tables.

lead4pass 70-779 exam question q12

There is a relationship between Products and ProductCategory.
You need to create a hierarchy in Products that contains ProductCategoryName and ProductName.
Solution: You create a measure that uses the ISCROSSFILTERED DAX function
Does this meet the goal?
A. Yes

B. No
Correct Answer: B

QUESTION 13
From a workbook query, you import a table that has the following data.

lead4pass 70-779 exam question q13

A. From the Format menu, click Trim.
B. From the Format menu, click Clean.
C. From the Split Column menu, click By Delimiter.
D. From the Extract menu, click Last Characters.
Correct Answer: C

Latest Lead4Pass Year-round Discount Code 2020

lead4pass coupon 2020

Why Lead4Pass is the industry leader

Lead4Pass has many years of exam experience! Finishing school is your goal! Getting good employment conditions is your goal!
Our goal is to help more people pass the Microsoft exam! Exams are a part of life but important!
In the study, you need to make great efforts, to sum up, the study! Trust Lead4Pass if you can’t easily pass because of exam details!
We have the most authoritative Microsoft exam experts! The most efficient pass rate! We are an industry leader!
why lead4pass

Summarize:

This blog shares the latest Microsoft 70-779 exam dumps, 70-779 exam questions, and answers! 70-779 pdf, 70-779 exam video!
You can also practice the test online! Lead4pass is the industry leader!
Select Lead4Pass 70-779 exams Pass Microsoft 70-779 exams “Analyzing and Visualizing Data with Microsoft Excel”.
Help you successfully pass the 70-779 exam.

ps.

Latest update Lead4pass 70-779 exam dumps: https://www.leads4pass.com/70-779.html (115 Q&As)

[Q1-Q12 PDF] Free Microsoft 70-779 pdf dumps download from Google Drive: https://drive.google.com/file/d/1eya9rudoHjL_pmpk1Z4LHiSSivpusD-d/

Best way to pass the Microsoft 70-742 exam – 100% free

What is the best way to pass the Microsoft 70-742 exam? (First: Exam practice test, Second: Lead4pass Microsoft expert.) You can get free Microsoft MCSA 70-742 exam practice test questions here. Or choose https://www.leads4pass.com/70-742.html (280 Q&As). Study hard to pass the exam easily!

Table of Contents:

Latest Microsoft MCSA 70-742 google drive

[PDF] Free Microsoft MCSA 70-742 pdf dumps download from Google Drive: https://drive.google.com/open?id=1z-4YLX55xHk9HRL327wpY62cc34TvGSa

Exam 70-742: Identity with Windows Server 2016 – Microsoft:https://www.microsoft.com/en-us/learning/exam-70-742.aspx

Skills measured

This exam measures your ability to accomplish the technical tasks listed below.

  • Install and Configure Active Directory Domain Services (AD DS) (20-25%)
  • Manage and Maintain AD DS (15-20%)
  • Create and Manage Group Policy (25-30%)
  • Implement Active Directory Certificate Services (AD CS) (10-15%)
  • Implement Identity Federation and Access Solutions (15-20%)

Who should take this exam?

Candidates for this exam manage identities using the functionalities in Windows Server 2016. Candidates install, configure, manage, and maintain Active Directory Domain Services (AD DS) as well as implement Group Policy Objects (GPOs).

Candidates should also be familiar with implementing and managing Active Directory Certificate Services (AD CS), Active Directory Federations Services (AD FS), Active Directory Rights Management Services (AD RMS), and Web Application proxy.

Latest updates Microsoft 70-742 exam practice questions

QUESTION 1
Your network contains an Active Directory domain named contoso.com. The domain contains a server named Server1
that runs a Server Core installation of Windows Server 2016. Server1 is configured as an Active Directory Rights
Management Services (AD RMS) server for the domain.
You need to install the Identity Federation Support role service on Server1.
What should you do first?
A. Run the Install–WindowsFeature NET–Franework
Correct Answer: C

QUESTION 2
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.
Start of repeated scenario.
Your network contains an Active Directory domain named contoso.com. The domain contains a single site named Site1.
All computers are in Site1.
The Group Policy objects (GPOs) for the domain are configured as shown in the exhibit. (Click the Exhibit button.)lead4pass 70-742 exam question q2

The relevant users and client computer in the domain are configured as shown in the following table.

lead4pass 70-742 exam question q2-1

End of repeated scenario.
You are evaluating what will occur when you set user Group Policy loopback processing mode to Replace in A4.
Which GPO or GPOs will apply to User2 when the user signs in to Computer1 after loopback processing is configured?
A. A1, A5, A6 and A4
B. A3, A1, A4, and A7
C. A3, A1, A5 and A4
D. A4 only
Correct Answer: D

QUESTION 3
You have an enterprise certification authority (CA) named CA1.
You have a certificate template named UserAutoEnroll that is based on the User certificate template. Domain users are
configured to autoenroll for UserAutoEnroll. A user named User1 has an email address defined in Active Directory. A
user
named User2 does not have an email address defined in Active Directory.
You discover that User1 was issued a certificate based on UserAutoEnroll template automatically.
A request by user2 for a certificate based on the UserAutoEnroll template fails.
You need to ensure that all users can autoenroll for certificated based on the UserAutoEnroll template.
Which setting should you configure from the properties on the UserAutoEnroll certificate template?
A. Issuance Requirements
B. Request Handling
C. Cryptography
D. Subject Name
Correct Answer: D

QUESTION 4
Your network contains an Active Directory forest named contoso.com. The forest contains 10 domains. The root domain
contains a global catalog server named DC1.
You remove the global catalog server role from DC1.
You need to decrease the size of the Active Directory database on DC1.
Solution: You restart DC1 in Directory Services Repair Mode. You run compact.exe, and then restart DC1.
Does this meet the goal?
A. Yes
B. No
Correct Answer: B
You need to run ntdsutil.exe with the `compact to\\’ option.
References: https://theitbros.com/active-directory-database-compact-defrag/

QUESTION 5
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 the stated goals.
Your network contains an Active Directory domain named contoso.com.
The domain contains a DNS server named Server1. All client computers run Windows 10.
On Server1, you have the following zone configuration.lead4pass 70-742 exam question q5

You need to ensure that all of the client computers in the domain perform DNSSEC validation for the fabrikam.com
namespace.
Solution: From a Group Policy object (GPO) in the domain, you add a rule to the Name Resolution Policy Table
(NRPT).
Does this meet the goal?
A. Yes
B. No
Correct Answer: A
The NRPT stores configurations and settings that are used to deploy DNS Security Extensions (DNSSEC), and also
stores information related to DirectAccess, a remote access technology. Note: The Name Resolution Policy Table
(NRPT) is a new feature available in Windows Server 2008 R2. The NRPT is a table that contains rules you can
configure to specify DNS settings or special behavior for names or namespaces. When performing DNS name
resolution, the DNS Client service checks the NRPT before sending a DNS query. If a DNS query or response matches
an entry in the NRPT, it is handled according to settings in the policy. Queries and responses that do not match an
NRPT entry are processed normally.
References: https://technet.microsoft.com/en-us/library/ee649207(v=ws.10).aspx

QUESTION 6
Your network contains an Active Directory domain named contoso.com. The domain contains two servers named
Server1 and Server2 that run Windows Server 2016.
Server1 has Microsoft System Center 2016 Virtual Machine Manager (VMM) installed.
Server2 has IP Address Management (IPAM) installed.
You create a domain user named User1.
You need to integrate IPAM and VMM. VMM must use the account of User1 to manage IPAM. The solution must use
the principle of least privilege.
What should you do on each server? To answer, select the appropriate options in the answer area
Hot Area:lead4pass 70-742 exam question q6

Correct Answer:

lead4pass 70-742 exam question q6-1

References: https://technet.microsoft.com/en-us/library/dn783349(v=ws.11).aspx

QUESTION 7
Your network contains an Active Directory domain named contoso.com.
The domain contains a read-only domain controller (RODC) named RODC1.
You need to retrieve a list of accounts that have their password cached on RODC1.
Which command should you run?
A. repadmin.exe
B. ntdsutil.exe
C. dcdiag.exe
D. netdom.exe
Correct Answer: A
To list the user and computer accounts for the passwords that are cached on the RODC, run the following command:
repadmin /prp view reveal
References https://support.microsoft.com/en-za/help/2028962/the-active-directory-users-and-computers-mmc-snap-in-does-not-list-all

QUESTION 8
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 section, you will NOT be able to return to it. As a result, these questions will not
appear in the review screen.
Your network contains an Active Directory domain named contoso.com. The domain contains a server named Server1
that runs Windows Server 2016. The computer account for Server1 is in organizational unit (OU) named OU1.
You create a Group Policy object (GPO) named GPO1 and link GPO1 to OU1.
You need to add a domain user named User1 to the local Administrators group on Server1.
Solution: From the Computer Configuration node of GPO1, you configure the Local Users and Groups preference.
Does this meet the goal?
A. Yes
B. No
Correct Answer: A
to add uses to the Local Administrator built In group on all the computers using Group Policy, open group policy editor
and create or edit existing GPO. Go to User Configuration -> Preferences -> Control Panel Settings -> Local users and
groups.
References: https://www.ntweekly.com/2015/01/10/how-to-add-users-to-local-admin-group-using-group-policy-windows-server-2012/

QUESTION 9
HOTSPOT
Your network contains an Active Directory domain named contoso.com.
You open Group Policy Management as shown in the Group Policy Management exhibit.
(Click the Exhibit button.)lead4pass 70-742 exam question q9

A user named User1 is in OU1. A computer named Computer2 is in OU2.
The settings of GPO1 are configured as shown in the GPO1 exhibit. (Click the Exhibit button.)

lead4pass 70-742 exam question q9-1

The settings of GPO2 are configured as shown in the GPO2 exhibit. (Click the Exhibit button.)

lead4pass 70-742 exam question q9-2

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct
selection is worth one point.
Hot Area:

lead4pass 70-742 exam question q9-3

Correct Answer:

lead4pass 70-742 exam question q9-4

QUESTION 10
HOTSPOT
Your network contains an Active Directory domain named contoso.com. The domain contains an administrative
workstation named WKS1 that runs Windows 10.
You have a Group Policy object (GPO) named GPO1.
You download a custom administrative template that contains the following files:
App1.admx App1.adml You need to ensure that you can configure GPO1 by using the settings in the new administrative
template.
To where should you copy each file? To answer, select the appropriate options in the answer area. NOTE: Each correct
selection is worth one point.
Hot Area:lead4pass 70-742 exam question q10

Correct Answer:

lead4pass 70-742 exam question q10-1

QUESTION 11
Your company has an office in Montreal. The network contains an Active Directory domain named contoso.com.
You have an organizational unit (OU) named Montreal that contains all of the users accounts for the users in the
Montreal office. An office manager in the Montreal office knows each user personally.
You need to ensure that the office manager can provide the users with a new password if the users forget their
password.
What should you do?
A. Create a Group Policy object (GPO) and link the GPO to the Montreal OU. Assign the office manager the Apply
Group Policy permission on the GPO. Configure the Password Policy settings of the GPO.
B. From the Security settings of each user account in the Montreal OU, assign the office manager the Change
Password permission.
C. From the Security settings of the Montreal OU, assign the office manager the Reset Password permission.
D. Create a Group Policy object (GPO) and link the GPO to the OU of the domain. Filter the GPO to the Montreal users.
Assign the office manager the Apply Group Policy permission on the GPO. Configure the Password Policy settings of
the GPO.
Correct Answer: C

QUESTION 12
Your network contains an Active Directory domain named contoso.com.
You need to view a list of all the domain user accounts that are enabled. But whose users have not signed in during the
last 30 days.
Which command should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:lead4pass 70-742 exam question q12

Correct Answer:

lead4pass 70-742 exam question q12-1

QUESTION 13
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 section, you will NOT be able to return to it. As a result, these questions will not
appear in the review screen.
Your network contains an Active Directory forest named contoso.com.
You need to identify which server is the schema master.
Solution: From Windows PowerShell, you run Get-ADDomainController –Discover –Service 2.
Does this meet the goal?
A. Yes
B. No
Correct Answer: B
This command gets a global catalog in the current forest using Discovery.
References: https://docs.microsoft.com/en-us/powershell/module/addsadministration/get-addomaincontroller?view=win10-ps

Related 70-742 Popular Exam resources

title pdf youtube Microsoft lead4pass Lead4Pass Total Questions
Microsoft MCSA lead4pass 70-742 dumps pdf lead4pass 70-742 youtube Exam 70-742: Identity with Windows Server 2016 – Microsoft https://www.leads4pass.com/70-742.html 280 Q&A
lead4pass 70-740 dumps pdf lead4pass 70-740youtube Installation, Storage, and Compute with Windows Server 2016 https://www.leads4pass.com/70-740.html 337 Q&A
lead4pass 70-741 dumps pdf lead4pass 70-741 youtube Exam 70-741: Networking with Windows Server 2016 – Microsoft https://www.leads4pass.com/70-741.html 259 Q&A
lead4pass 70-743 dumps pdf lead4pass 70-743 youtube Upgrading Your Skills to MCSA: Windows Server 2016 https://www.leads4pass.com/70-743.html 267 Q&A

Lead4Pass Year-round Discount Code

lead4pass coupon

What are the advantages of Lead4pass?

Lead4pass employs the most authoritative exam specialists from Microsoft, Cisco, CompTIA, IBM, EMC, etc. We update exam data throughout the year. Highest pass rate! We have a large user base. We are an industry leader! Choose Lead4Pass to pass the exam with ease!

why lead4pass

Summarize:

It’s not easy to pass the Microsoft 70-742 exam, but with accurate learning materials and proper practice, you can crack the exam with excellent results. Lead4pass provides you with the most relevant learning materials that you can use to help you prepare.

Best way to pass the Microsoft 70-741 exam – 100% free

What is the best way to pass the Microsoft 70-741 exam? (First: Exam practice test, Second: Lead4pass Microsoft expert.) You can get free Microsoft MCSA 70-741 exam practice test questions here. Or choose https://www.leads4pass.com/70-741.html (259 Q&As). Study hard to pass the exam easily!

Table of Contents:

Latest Microsoft MCSA 70-741 google drive

[PDF] Free Microsoft MCSA 70-741 pdf dumps download from Google Drive: https://drive.google.com/open?id=1DNB40m4ZzhtEFScQcPZ7PeiWFbXfIFUa

Exam 70-741: Networking with Windows Server 2016 – Microsoft:https://www.microsoft.com/en-us/learning/exam-70-741.aspx

Skills measured

This exam measures your ability to accomplish the technical tasks listed below.

  • Implement Domain Name System (DNS) (15-20%)
  • Implement DHCP and IPAM (25-30%)
  • Implement Network Connectivity and Remote Access Solutions (20-25%)
  • Implement Core and Distributed Network Solutions (15-20%)
  • Implement an Advanced Network Infrastructure (15-20%)

Who should take this exam?

Candidates for this exam perform tasks related to the networking features and functionalities available in Windows Server 2016. Candidates should have familiarity with implementing and managing DNS, DHCP, and IPAM, as well as deploying remote access solutions such as VPN and RADIUS.

Candidates should also have experience managing DFS and branch cache solutions, configuring high-performance network features and
functionality, and implementing Software Defined Networking (SDN) solutions such as Hyper-V Network Virtualization (HNV) and Network Controller.

Latest updates Microsoft 70-741 exam practice questions

QUESTION 1
You have a DirectAccess Server that is accessible by using the name directaccess.fabrikam.com On the DirectAccess
server, you install a new server certificate that has a subject name of directaccess.contoso.com, and then you configure
DNS records for directaccess.contoso.com You need to change the endpoint name for DirectAccess to
directaccess.contoso.com What command should you run? To answer, select the appropriate options in the answer
area.
Hot Area:lead4pass 70-741 exam question q1

Correct Answer:

lead4pass 70-741 exam question q1-1

QUESTION 2
You have an IP Address Management (IPAM) server named IPAM1 that runs Window Server 2016. IPAM1 manages all
of the DHCP servers on your network.
You are troubleshooting an issue for a client that fails to receive an IP address from DHCP.
You need to ensure that from IPAM1, you can view all of the event data for the DHCP leases from the last 24 hours.
Solution: From Server Manager, you run Retrieve Event Catalog Data.
Does this meet the goal?
A. Yes
B. No
Correct Answer: A
References: http://www.techblogopedia.com/blog/ip-address-managementipam-windows-server-2012-r2-part-3/

QUESTION 3
You have two servers named Server1 and Server2 that run Windows Server 2016.
Server1 has the DNS Server role installed. The advanced DNS properties for Server1 are shown in the Advanced DNS
exhibit. (Click the Exhibit button.)
Server2 is configured to use Server1 as a DNS server. Server2 has the following IP configuration.lead4pass 70-741 exam question q3 lead4pass 70-741 exam question q3-1

Select the appropriate selection if statement is “Yes” or No.
Hot Area: lead4pass 70-741 exam question q3-2

Correct Answer:

lead4pass 70-741 exam question q3-3

QUESTION 4
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 the stated goals.
Your network contains an Active Directory domain named contoso.com. The domain contains a DNS server named
Server1. All client computers run Windows 10.
On Server1, you have the following zone configuration.lead4pass 70-741 exam question q4

You need to ensure that all of the client computers in the domain perform DNSSEC validation for the fabrikam.com
namespace.
Solution: From Windows PowerShell on Server1, you run the Add-DnsServertrustAnchor cmdlet.
Does this meet the goal?
A. Yes
B. No
Correct Answer: B
The Add-DnsServerTrustAnchor command adds a trust anchor to a DNS server. A trust anchor (or trust “point”) is a
public cryptographic key for a signed zone. Trust anchors must be configured on every non- authoritative DNS server
that will
attempt to validate DNS data. Trust Anchors have no direct relation to DSSEC validation.
References: https://technet.microsoft.com/en-us/library/jj649932.aspx https://technet.microsoft.com/en-us/library/dn593672(v=ws.11).aspx

QUESTION 5
Your network contains an Active Directory domain. The domain contains a certification authority (CA) and a Network
Policy Server (NPS) server.
You plan to deploy Remote Access Always On VPN.
Which authentication method should you use?
A. Microsoft: EAP-TTLS
B. Microsoft: Secured password
C. Microsoft: Protected EAP
D. Microsoft: EAP-AKA
Correct Answer: C

QUESTION 6
You have a DNS server named Server1 that runs Windows Server 2016. Server1 has an Active Directory-integrated
zone named adatum.com.
All client computers run Windows 10.
You recently encountered unexpected responses to DNS client queries in the adatum.corn zone.
You need to log all the records written to the zone.
Which cmdlet should you run?
A. Set-DnsServerDsSetting
B. Set-DnsServerDiagnostics
C. Set-DnsServer
D. Add-DnaServerQueryResolutionPolicy
Correct Answer: B

QUESTION 7
Your network contains an Active Directory forest named contoso.com. The forest contains two domains named
contoso.com and litwareinc.com.
Your company recently deployed DirectAccess for the members of a group named DA_Computers. All client computers
are members of DA_Computers.
You discover that DirectAccess clients can access the resources located in the contoso.com domain only. The clients
can access the resources in the litwareinc.com domain by using an L2TP VPN connection to the network.
You need to ensure that the DirectAccess clients can access the resources in the litwareinc.com domain.
What should you do?
A. From a Group Policy object (GPO), modify the Name Resolution Policy Table (NRPT).
B. From the properties of the servers in litwareinc.com, configure the delegation settings.
C. On an external DNS server, create a zone delegation for litwareinc.com.
D. Add the servers in litwareinc.com to the RAS and IAS Servers group.
Correct Answer: A
https://blogs.technet.microsoft.com/tomshinder/2010/04/01/directaccess-client-location-awareness-nrpt-name-resolution/

QUESTION 8
You have two servers named Server1 and Server2 that run Windows Server 2016. Both servers have the DHCP Server
server role installed.
Server1 has a DHCP scope named Scope1. Server2 has a DHCP scope named Scope2.
You need to ensure that client computers can get an IP address if a single DHCP server fails. You must be able to
control the percentage of requests to which each DHCP server responds during normal network operations.
What should you do?
A. Add Server1 and Server2 as nodes in a failover cluster, and then configure the DHCP Server server role.
B. Add Server1 and Server2 as nodes in a failover cluster, and then configure the quorum mode.
C. On Server1 and Server2, configure DHCP failover for Scope1 and Scope2.
D. Add Server1 and Server2 as nodes in a failover cluster, and then configure port rules for UDP 67 and UDP 68.
Correct Answer: C

QUESTION 9
You have an IP Address Management (IPAM) server named IPAM1 that runs Window Server 2016. IPAM1 manages all
of the DHCP servers on your network.
You are troubleshooting an issue for a client that fails to receive an IP address from DHCP. You need to ensure that
from IPAM1, you can view all of the event data for the DHCP leases from the last 24 hours.
Solution: From Windows PowerShell, you run the Set-IpamDHCPServer cmdlet.
Does this meet the goal?
A. Yes
B. No
Correct Answer: B

QUESTION 10
You are configuring internal virtual networks to support multitenancy communication between tenant virtual machine
networks and remote sites.
You have a tenant named Tenant1.
You need to enable Border Gateway Protocol (BGP) for Tenant1.
Which commands should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:lead4pass 70-741 exam question q10

Correct Answer:

lead4pass 70-741 exam question q10-1

QUESTION 11
You have a Hyper-V host named Server1 that runs Windows Server 2016. Server1 has two network adaptors named
NK1 and NIC2. Server2 has two virtual switches named vSwitch1 and vSwitch2. N1C1 connects to vSwitch1. NIC2
connects to vSwitch2
Server1 hosts a virtual machine named VM1. VM1 has two network adapters named vmNIC1 and vmNIC1. VmNIC1
connects to vSwitch1. VmNIC2 connects to vSwitch2.
You need to create a NIC team on VM1.
What should you run on VM1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:lead4pass 70-741 exam question q11

Correct Answer:

lead4pass 70-741 exam question q11-1

Name NICTEAM1 TeamMembers vmNIC1, vmNIC2 –TeamingMode $var1 –LoadBalancingAlgorithm $var2

QUESTION 12
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 network contains an Active Directory domain named contoso.com. The domain contains a member server named
Server1 that runs Windows Server 2016 and has the DNS Server role installed. Automatic scavenging of state records
is
enabled and the scavenging period is set to 10 days.
All client computers dynamically register their names in the contoso.com DNS zone on Server1.
You discover that the names of multiple client computers that were removed from the network several weeks ago can
still be resolved.
You need to configure Server1 to automatically remove the records of the client computers that have been offline for
more than 10 days.
Solution: You set the Expires after value of the zone.
Does this meet the goal?
A. Yes
B. No
Correct Answer: B
https://technet.microsoft.com/en-us/library/cc772069(v=ws.11).aspx

QUESTION 13
You have a Microsoft Azure subscription and an on-premises network.
To the on-premises network, you deploy a new server named Server1 that runs Windows Server 2016. In Azure, you
configure a virtual gateway on an Azure virtual network.
You need to ensure that the computers on the on-premises network can access virtual machines on the Azure virtual
network.
What should you do on Server1?
A. Install the Remote Access server role. From the Routing and Remote Access Server Setup Wizard, select Secure
connection between two private networks.
B. Install the Data Center Bridging (DCB) feature, and then run the Install-RemoteAccess cmdlet.
C. Install the Remote Access server role. From the Routing and Remote Access Server Setup Wizard, select Virtual
private network (VPN) access and NAT.
D. Install the Data Center Bridging (DCB) feature, and then run the Enable-RemoteAccessRoutingDomain cmdlet.
Correct Answer: A

Related 70-741 Popular Exam resources

title pdf youtube Microsoft lead4pass Lead4Pass Total Questions
Microsoft MCSA lead4pass 70-741 dumps pdf lead4pass 70-741 youtube Exam 70-741: Networking with Windows Server 2016 – Microsoft https://www.leads4pass.com/70-741.html 259 Q&A
lead4pass 70-740 dumps pdf lead4pass 70-740youtube Installation, Storage, and Compute with Windows Server 2016 https://www.leads4pass.com/70-740.html 337 Q&A
lead4pass 70-742 dumps pdf lead4pass 70-742 youtube Exam 70-742: Identity with Windows Server 2016 – Microsoft https://www.leads4pass.com/70-742.html 280 Q&A
lead4pass 70-743 dumps pdf lead4pass 70-743 youtube Upgrading Your Skills to MCSA: Windows Server 2016 https://www.leads4pass.com/70-743.html 267 Q&A

Lead4Pass Year-round Discount Code

lead4pass coupon

What are the advantages of Lead4pass?

Lead4pass employs the most authoritative exam specialists from Microsoft, Cisco, CompTIA, IBM, EMC, etc. We update exam data throughout the year. Highest pass rate! We have a large user base. We are an industry leader! Choose Lead4Pass to pass the exam with ease!

why lead4pass

Summarize:

It’s not easy to pass the Microsoft 70-741 exam, but with accurate learning materials and proper practice, you can crack the exam with excellent results. Lead4pass provides you with the most relevant learning materials that you can use to help you prepare.