You need to ensure that you can use the new certificate for AD FS
Your network contains a server named Server1 that runs Windows Server 2008 R2. Server1
is configured as an Active Directory Federation Services (AD FS) 2.0 standalone server.
You plan to add a new token-signing certificate to Server1.
You import the certificate to the server as shown in the exhibit. (Click the Exhibit button.)
When you run the Add Token-Signing Certificate wizard, you discover that the new
certificate is unavailable.
You need to ensure that you can use the new certificate for AD FS.
What should you do?
You need to purge the list of user accounts that were authenticated on a read-only domain controller (RODC)
You need to purge the list of user accounts that were authenticated on a read-only domain
controller (RODC).
What should you do?
You need to ensure that the domain controllers in the branch offices only replicate to the domain controller i
Your company has a main office and four branch offices. An Active Directory site exists for
each office. Each site contains one domain controller. Each branch office site has a site link
to the main office site.
You discover that the domain controllers in the branch offices sometimes replicate directly to
each other.
You need to ensure that the domain controllers in the branch offices only replicate to the
domain controller in the main office.
What should you do?
You need to ensure that you can add 1,000 new user accounts to the domain
Your network contains an Active Directory forest. The forest contains one domain. The
domain contains two domain controllers named DC1 and DC2 that run Windows Server
2008 R2.
DC1 was installed before DC2.
DC1 fails.
You need to ensure that you can add 1,000 new user accounts to the domain.
What should you do?
You need to identify whether the Active Directory Recycle Bin is enabled
Your network contains an Active Directory domain named contoso.com.
You need to identify whether the Active Directory Recycle Bin is enabled.
What should you do?
You need to ensure that you can browse the contents of the Active Directory snapshot
Your network contains an Active Directory domain.
You create and mount an Active Directory snapshot.
You run dsamain.exe as shown in the exhibit. (Click the Exhibit button.)
You need to ensure that you can browse the contents of the Active Directory snapshot.
What should you?
You need to design the database to ensure that that you can retrieve the following information: • The curren
You are designing a Windows Azure SQL Database for an order fulfillment system. You
create a table named Sales.Orders with the following script.
Each order is tracked by using one of the following statuses:
• Fulfilled
• Shipped
• Ordered
• Received
You need to design the database to ensure that that you can retrieve the following
information:
• The current status of an order
• The previous status of an order.
• The date when the status changed.
The solution must minimize storage.More than one answer choice may achieve the goal.
Select the BEST answer.
What should you recommend?
You create a stored procedure that retrieves all of the rows from a table named Table1.
You need to recommend a solution to ensure that all of the statements in the stored
procedure can be executed if another transaction is modifying rows in Table1 simultaneously.
What should you recommend?
What should you recommend?
You have a SQL Server instance on a server named Server1.
You need to recommend a solution to perform the following tasks every week:
• Rebuild the indexes by using a new fill factor.
• Run a custom T-SQL command.
• Back up the databases.
What should you recommend?More than one answer choice may achieve the goal. Select
the BEST answer.
Which columns should you designate as SPARSE?
HOTSPOT
You use SQL Server 2014. You create a table within a database by using the following DDL:
The following table illustrates a representative sample of data:
The system is expected to handle 50 million orders a month over the next five years.
You have been instructed by your Team Lead to follow best practices for storage and
performance in the utilization of SPARSE columns.
Which columns should you designate as SPARSE? To answer, mark each column as
SPARSE or NOT SPARSE in the answer area.