Which cmdlet should you run?
Your network contains an Active Directory forest named contoso.com. The forest contains a single
domain. The domain contains two domain controllers named DC1 and DC2 that run Windows Server
2012 R2.
The domain contains a user named User1 and a global security group named Group1.
You reconfigure DC2 as a member server in the domain.
You need to add DC2 as the first domain controller in a new domain in the forest.
Which cmdlet should you run?
Which TransactSQL statement should you use?
You have two tables. A table named Student.CurrentStudents contains the names of all students
enrolled for the current year. Another table named Student.NewYearRoster contains the names of
students who have enrolled for the upcoming year.
You have been tasked to write a MERGE statement to:
Insert into Student.CurrentStudents the names of students who are enrolled for the upcoming year
but
not for the current year.
Update information in Student.CurrentStudents for students who are enrolled both in the current
year
and in the upcoming year.
Delete from Student.CurrentStudents the names of students who are not enrolled for the upcoming
year.
You need to write the appropriate MERGE statement.
Which TransactSQL
statement should you use?
Which Transact-SQL statement(s) should you execute in the DB1 database?
You administer a SQL Server 2008 instance for a company named Contoso Ltd. The
instance contains a database named DB1.
A Windows group named CONTOSO\Managers can access the DB1 database.
CONTOSO\Managers is a member of the db_owner role in the DB1 database.
A Windows user named User1 is a member of the CONTOSO\Managers group.
You need to ensure that User1 is unable to access the SQL Server instance.
Which Transact-SQL statement(s) should you execute in the DB1 database?
What should you configure?
Your network contains a server named Server1 that runs Windows Server 2012 R2.Server1 has the
Hyper-V server role installed.
Server1 hosts four virtual machines named VM1, VM2, VM3, and VM4.
Server1 is configured as shown in the following table.
You install a network monitoring application on VM2.
You need to ensure that all of the traffic sent to VM3 can be captured on VM2.
What should you configure?
Which two configurations should you perform?
You have a Hyper-V host named Host1 that connects to a SAN by using a hardware Fibre Channel
adapter.
Host1 contains two virtual machines named VM1 and VM2.
You need to provide VM1 with direct access to the SAN. VM2 must not require access to the SAN.
Which two configurations should you perform? (Each correct answer presents part of the solution.
Choose two.)
You need to modify the snapshot file location of VM1
You have a Hyper-V host named Server1 that runs Windows Server 2012 R2.
Server1 hosts a virtual machine named VM1 that runs Windows Server 2012 R2.
VM1 has several snapshots.
You need to modify the snapshot file location of VM1.
What should you do?
Which action should you select from the Edit Virtual Hard Disk Wizard?
You have virtual machine named VM1.
VM1 uses a fixed size virtual hard disk (VHD) named Disk1.vhD. Disk1.vhd is 200 GB.
You shut down VM1.
You need to reduce the size of disk1.vhd.
Which action should you select from the Edit Virtual Hard Disk Wizard?
You need to ensure that the user can successfully execute Procedure1 without violating the business requiremen
You administer a SQL Server 2008 instance that contains a database named DB1. DB1
contains a table named Table1.
The DB1 database includes a stored procedure named Procedure1. Procedure 1 uses a
sp_executesql Transact-SQL statement to select data from Table1.
According to business requirements, users are not allowed to access tables directly in any
database.
When a user executes Procedure1, the following exception is raised:
“Msg 229, Level 14, State 5, Line 1
The SELECT permission was denied on the object Table1′, database ‘DB1’, schema ‘dbo’.”
You need to ensure that the user can successfully execute Procedure1 without violating the
business requirements.
What should you do?
Which tool should you use?
Your network contains an Active Directory domain named contoso.com. The domain contains a
server named Server1. Server1 runs Windows Server 2012 R2.
You need to create a 3-TB virtual hard disk (VHD) on Server1.
Which tool should you use?
Which total number of rows should you choose?
You create and populate two tables by using the following TransactSQL
statements:
CREATE TABLE CurrentStudents (LastName VARCHAR(50),
FirstName VARCHAR(50),
Address VARCHAR(100),
Age INT);
INSERT INTO CurrentStudents
VALUES (‘Fritz’, ‘David’, ‘181 Kline Street’, 14)
,(‘Reese’, ‘Paul’ , ‘4429 South Union’, 14)
,(‘Brown’, ‘Jake’ , ‘5401 Washington Ave’,14)
,(‘Smith’, ‘Tom’ , ‘124 Water St’, 14)
,(‘Holtz’, ‘Mary’ , ‘984 Mass Ct’, 14)
,(‘Robbins’, ‘Jan’ , ‘4449 Union Ave’, 14)
,(‘Larsen’, ‘Frank’ , ‘5812 Meadow St’, 14)
,(‘Bishop’, ‘Cathy’ , ‘14429 Skyhigh Ave’, 14)
,(‘Francis’, ‘Thomas’ , ‘15401 120th St’, 14)
CREATE TABLE NewYearRoster(LastName VARCHAR(50),
FirstName VARCHAR(50),
Address VARCHAR(100),
Age INT);
INSERT INTO NewYearRoster
VALUES (‘Fritz’, ‘David’, ‘181 Kline Street’, 15)
,(‘Reese’, ‘Paul’, ‘1950 Grandview Place’, 15)
,(‘Adams’, ‘Wilbur’, ‘4231 W. 93rd’, 15)
,(‘Adams’, ‘Norris’, ‘100 1st Ave’, 15)
,(‘Thomas’, ‘Paul’, ‘18176 Soundview Dr’, 15)
,(‘Linderson’, ‘Danielle’, ‘941 W. 37 Ave’, 15)
,(‘Moore’, ‘Joshua’, ‘2311 10st Ave’, 15)
,(‘Dark’, ‘Shelby’, ‘1987 Fifth Ave’, 15)
,(‘Scharp’, ‘Mary’, ‘1902 W. 303rd’, 15)
,(‘Morris’, ‘Walt’, ‘100 12st St’, 15);
You run the following MERGE statement to update, insert and delete rows in the CurrentStudents
table
MERGE TOP (3) CurrentStudents AS T
USING NewYearRoster AS S
ON S.LastName = T.LastName AND S.FirstName = T.FirstName
WHEN MATCHED AND NOT (T.Age = S.Age OR T.Address = S.Address) THEN
UPDATE SET Address = S.Address,
Age = S.Age
WHEN NOT MATCHED BY TARGET THEN
INSERT (LastName, FirstName, Address, Age)
VALUES (S.LastName, S.FirstName, S.Address, S.Age)
WHEN NOT MATCHED BY SOURCE THEN
DELETE;
You need to identify the total number of rows that are updated, inserted, and deleted in the
CurrentStudent table. Which total number of rows should you choose?