You need to configure Server1 to support the client connections from App1.exe
Your network contains an Active Directory domain named contoso.com. The domain contains an
Application server named Server1. Server1 runs Windows Server 2012 R2.
Server1 is configured as an FTP server.
Client computers use an FTP Application named App1.exe. App1.exe uses TCP port 21 as the control
port and dynamically requests a data port.
On Server1, you create a firewall rule to allow connections on TCP port 21.
You need to configure Server1 to support the client connections from App1.exe.
What should you do?
Which results should the query produce?
You have two tables named dbo.Products and dbo.PriceChange. Table dbo.Products contains ten
products. Five products are priced at $20 per unit and have PriceIncrease set to 1. The other five
products
are priced at $10 per unit and have PriceIncrease set to 0.
You have the following query:
INSERT dbo.PriceChange (ProductID, Change, ChangeDate)
SELECT ProductID, inPrice delPrice,
SYSDATETIME()
FROM
(
UPDATE dbo.Products
SET Price *= 1.1
OUTPUT inserted.ProductID, inserted.Price, deleted.Price
WHERE PriceIncrease = 1
) p (ProductID, inPrice, delPrice)Íž
You need to predict the results of the query.
Which results should the query produce?
Which Windows Firewall rule should you create on Server1?
Your network contains an Active Directory domain named contoso.com.
All client computers run Windows 8.
You deploy a server named Server1 that runs Windows Server 2012 R2.
You install a new client-server application named App1 on Server1 and on the client computers. The
client computers must use TCP port 6444 to connect to App1 on Server1.Server1 publishes the
information of App1 to an intranet server named Server2 by using TCP port 3080.
You need to ensure that all of the client computers can connect to App1. The solution must ensure
that the application can connect to Server2.
Which Windows Firewall rule should you create on Server1?
Which is the correct answer?
You are managing a SQL Server 2008 computer called SQLTEST1. You should configure
the SQL Server service and the SQL Server Agent service to start automatically, and set
SQLTEST1 to audit all user names and application names that plan to get information from
SQLTEST1. SQLTEST1 must operate auditing always, and you should keep the results for
10 years. Which is the correct answer?
Which tool should you use?
Your network contains an Active Directory domain named contoso.com. The domain contains two
servers named Server1 and Server2 that run Windows Server 2012 R2.
You create a security template named Template1 by using the security template snap-in.
You need to apply Template1 to Server2.
Which tool should you use?
You need to ensure that client computers can resolve single-label names to IP addresses
Your network contains multiple subnets.
On one of the subnets, you deploy a server named Server1 that runs Windows Server 2012 R2.
You install the DNS Server server role on Server1, and then you create a standard primary zone
named contoso.com.
You need to ensure that client computers can resolve single-label names to IP addresses.
What should you do first?
You need to ensure that the clients in both sites receive their IPv4 configurations from Server1
HOTSPOT
Your network contains an Active Directory domain named contoso.com. The domain contains a
single location named Site1. The domain contains a server named Server1 that has the DHCP Server
server role installed.
All client computers receive their IPv4 configurations dynamically.
The domain will expand to include a second location named Site2. A server named Server2 will be
deployed to Site2. Site1 and Site2 will connect to each other by using a WAN link.
You need to ensure that the clients in both sites receive their IPv4 configurations from Server1.
In the table below, identify which actions must be performed on each server. Make only one
selection in each row. Each correct selection is worth one point.
You need to ensure that only the client computers in the Active Directory domain can register records in the c
Your network contains an Active Directory domain named contoso.com. The DNS zone for
contoso.com is Active-Directory integrated.
The domain contains 500 client computers. There are an additional 20 computers in a workgroup.
You discover that every client computer on the network can add its record to the contoso.com zone.
You need to ensure that only the client computers in the Active Directory domain can register
records in the contoso.com zone.
What should you do?
Which service should you configure?
You maintain a default SQL Server 2008 instance.
You plan to configure FILESTREAM data to meet the following requirements:
-Enable FILESTREAM for file I/O streaming access. -Allow remote client computers to have
streaming access to FILESTREAM data.
You need to ensure that FILESTREAM data is enabled.
Which service should you configure?
You need to ensure that when you run Nslookup, the correct name of the default server is displayed
Your network contains an Active Directory domain named contoso.com. The domain contains a
domain controller named Server1 that has the DNS Server server role installed. Server1 hosts a
primary zone for contoso.com.
The domain contains a member server named Server2 that is configured to use Server1 as its
primary DNS server.
From Server2, you run nslookup.exe as shown in the exhibit. (Click the Exhibit button.)
You need to ensure that when you run Nslookup, the correct name of the default server is displayed.
What should you do?