[Free] Download New Updated (October 2016) Microsoft 70-463 Real Exam 21-30

EnsurepassQUESTION 21 You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment. You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing the effects of setting IsolationLevel transaction property of a Data Flow task to Chaos. Which of the following suitably describes the effect? A.     It prevents pending Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-463 Real Exam 11-20

EnsurepassQUESTION 11 You develop and deploy a SQL Server Integration Services (SSIS) package. The package is stored in the file system. You need to execute the package without importing it to the SSIS server. What should you use to execute the package? (Each correct answer presents a complete solution. Choose all that apply.)   A.     catalog.start_package B.      dtexec C.      SQL Server Management Studio D.     Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-463 Real Exam 1-10

EnsurepassQUESTION 1 You are implementing a SQL Server Integration Services (SSIS) package that loads data hosted in a SQL Azure database into a data warehouse. The source system contains redundant or inconsistent data. When the package finds invalid data, the row containing the invalid data must be omitted but it must also be written to a text file for further analysis. You need to establish the best technique to log these invalid rows while keeping the amount of development effort to a minimum. Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 101-110

EnsurepassQUESTION 101 You want to add a new GUID column named BookGUID to a table named dbo.Book that already contains data. BookGUID will have a constraint to ensure that it always has a value when new rows are inserted into dbo.Book. You need to ensure that the new column is assigned a GUID for existing rows. Which four Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)   Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 91-100

EnsurepassQUESTION 91 You use Microsoft SQL Server 2012 database to develop a shopping cart application. You need to invoke a table-valued function for each row returned by a query. Which Transact-SQL operator should you use?   A. CROSS JOIN B. UNPIVOT C. PIVOT D. CROSS APPLY   Correct Answer: D Explanation: http://msdn.microsoft.com/en-us/library/ms175156.aspx     QUESTION 92 You develop a database application for a university. You need to create a view that will Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 111-120

EnsurepassQUESTION 111 Why is it important to use standard SQL code when possible and know what is standard and what isn't? (Choose all that apply.)   A. It is not important to code using standard SQL. B. Standard SQL code is more portable between platforms. C. Standard SQL code is more efficient. D. Knowing what standard SQL code is makes your knowledge more portable.   Correct Answer: BD     QUESTION 112 Which of the following is not a violation of the relational Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 81-90

EnsurepassQUESTION 81 You use a contained database named ContosoDb within a domain. You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations. Which type of user should you create?   A. User mapped to a certificate B. SQL user without login C. Domain user D. SQL user with login   Correct Answer: C Explanation: http://msdn.microsoft.com/en-us/library/ff929071.aspx Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 71-80

EnsurepassQUESTION 71 You use a contained database named ContosoDb within a domain. You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations. Which type of user should you create?   A. SQL user without login B. SQL user with a custom SID C. SQL user with login D. Domain user   Correct Answer: D     QUESTION Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 61-70

EnsurepassQUESTION 61 You develop a Microsoft SQL Server 2012 database. You create a view from the Orders and OrderDetails tables by using the following definition.     You need to ensure that users are able to modify data by using the view. What should you do?   A. Create an AFTER trigger on the view. B. Modify the view to use the WITH VIEW_METADATA clause. C. Create an INSTEAD OF trigger on the view. D. Modify the view to an indexed view.   Correct Answer: C Explanation: Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 51-60

EnsurepassQUESTION 51 You are writing a set of queries against a FILESTREAM-enabled database. You create a stored procedure that will update multiple tables within a transaction. You need to ensure that if the stored procedure raises a run-time error, the entire transaction is terminated and rolled back. Which Transact-SQL statement should you include at the beginning of the stored procedure?   A. SET TRANSACTION ISOLATION LEVEL SERIALIZABLE B. SET XACT_ABORT OFF C. SET TRANSACTION Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 41-50

EnsurepassQUESTION 41 You have a database that contains the tables as shown in the exhibit.     You have the following query:     You need to recreate the query to meet the following requirements:   - Reference columns by using one-part names only. - Sort aggregates by SalesTerritoryID, and then by ProductID. - Order the results in descending order from SalesTerritoryID to ProductID. - The solution must use the existing SELECT clause and FROM clause.   Which code Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 31-40

EnsurepassQUESTION 31 You are developing a database that will contain price information. You need to store the prices that include a fixed precision and a scale of six digits. Which data type should you use?   A. Float B. Money C. Smallmoney D. Numeric   Correct Answer: D Explanation: Numeric is the only one in the list that can give a fixed precision and scale. http://msdn.microsoft.com/en-us/library/ms179882.aspx     QUESTION 32 You administer a Microsoft SQL Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 21-30

EnsurepassQUESTION 21 You develop a database for a travel application. You need to design tables and other database objects. You need to store media files in several tables. Each media file is less than 1 MB in size. The media files will require fast access and will be retrieved frequently. What should you do?   A. Use the CAST function. B. Use the DATE data type. C. Use the FORMAT function. D. Use an appropriate collation. E. Use a user-defined table type. F. Use the VARBINARY Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 11-20

EnsurepassQUESTION 11 Your database contains two tables named DomesticSalesOrders and InternationalSalesOrders. Both tables contain more than 100 million rows. Each table has a Primary Key column named SalesOrderId. The data in the two tables is distinct from one another. Business users want a report that includes aggregate information about the total number of global sales and total sales amounts. You need to ensure that your query executes in the minimum possible time. Which query should you use? Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 1-10

EnsurepassQUESTION 1 You develop a Microsoft SQL Server 2012 server database that supports an application. The application contains a table that has the following definition:   CREATE TABLE Inventory (ItemID int NOT NULL PRIMARY KEY, ItemsInStore int NOT NULL, ItemsInWarehouse int NOT NULL)   You need to create a computed column that returns the sum total of the ItemsInStore and ItemsInWarehouse values for each row. Which Transact-SQL statement should you use?   A. ALTER TABLE Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 231-240

EnsurepassQUESTION 231 Your network contains an Active Directory domain named contoso.com. Domain controllers run either Windows Server 2008, Windows Server 2008 R2, or Windows Server 2012. You have a Password Settings object (PSOs) named PSO1. You need to view the settings of PSO1. Which tool should you use?   A. Group Policy Management B. Get-ADFineGrainedPasswordPolicy C. Get-ADDefaultDomainPasswordPolicy D. Server Manager   Correct Answer: B     QUESTION 232 Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 251-260

EnsurepassQUESTION 251 Your network contains an Active Directory domain named contoso.com. The domain contains 2 WSUS servers, ServerA and ServerB. ServerB is a replica server of ServerA. You need to configure WSUS to report data from SERVERB to SERVERA. What should you configure?   A. Update Reports B. Synchronization C. Computer Groups D. Reporting Rollup   Correct Answer: D   QUESTION 252 HOTSPOT Your network contains an Active Directory domain named adatum.com. You Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 241-250

EnsurepassQUESTION 241 You have a Direct Access Server named Server1 running Server 2012. You need to add prevent users from accessing websites from an Internet connection. What should you configure?   A. Split Tunneling B. Security Groups C. Force Tunneling D. Network Settings   Correct Answer: C     QUESTION 242 Your network contains an Active Direct ory domain named contoso.com. The domain does not contain a certification authority (CA). All servers run Windows Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 221-230

EnsurepassQUESTION 221 Your network contains an Active Directory domain named contoso.com. The domain contains more than 100 Group Policy objects (GPOs). Currently, there are no enforced GPOs. The domain contains a GPO named GPO1. GPO1 contains several Group Policy preferences. You need to view all of the preferences configured in GPO1. What should you use?   A. dcgpofix B. Get-GPOReport C. Gpfixup D. Gpresult E. Gptedit.msc F. Import-GPO G. Restore-GPO H. Set-GPInheritance Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 211-220

EnsurepassQUESTION 211 Your network contains an Active Directory domain named adatum.com. The domain contains a server named Server1 that runs Windows Server 2012 R2. Server1 is configured as a Network Policy Server (NPS) server and as a DHCP server.   The network contains two subnets named Subnet1 and Subnet2. Server1 has a DHCP scope for each subnet.   You need to ensure that noncompliant computers on Subnet1 receive different network policies than noncompliant computers on Subnet2.   Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 201-210

EnsurepassQUESTION 201 Your network is configured as shown in the exhibit. (Click the Exhibit button.)     Server1 regularly accesses Server2.   You discover that all of the connections from Server1 to Server2 are routed through Routerl.   You need to optimize the connection path from Server1 to Server2.   Which route command should you run on Server1?   A. Route add -p 192.168.2.0 MASK 255.255.255.0 192.168.2.1 METRIC 50 B. Route add -p 192.168.2.12 MASK 255.255.255.0 Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 191-200

EnsurepassQUESTION 191 Your network contains an Active Directory domain named adatum.com. All domain controllers run Windows Server 2012 R2. The domain contains a virtual machine named DC2.   On DC2, you run Get-ADDCCIoningExcludedApplicationList and receive the output shown in the following table.     You need to ensure that you can clone DC2.   Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)     A. Option Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 171-180

EnsurepassQUESTION 171 You have a server named Server1 that runs Windows Server 2012 R2. Server1 has the Windows Server Update Services server role installed.   Server1 stores update files locally in C:Updates.   You need to change the location in which the update files are stored to D:Updates.   What should you do?   A. From the Update Services console, run the Windows Server Update Services Configuration Wizard. B. From a command prompt, run wsusutil.exe and specify Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 151-160

EnsurepassQUESTION 151 Your network contains an Active Directory domain named contoso.com. The domain contains two member servers named Server1 and Server2. All servers run Windows Server 2012 R2.   Server1 and Server2 are nodes in a Hyper-V cluster named Cluster1. Cluster1 hosts 10 virtual machines. All of the virtual machines run Windows Server 2012 R2 and are members of the domain.   You need to ensure that the first time a service named Service1 fails on a virtual machine, the virtual Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 181-190

EnsurepassQUESTION 181 Your network contains a single Active Directory domain named contoso.com. The domain contains a member server named Server1 that runs Windows Server 2012 R2.   Server1 has the Windows Server updates Services server role installed and is configured to download updates from the Microsoft Update servers.   You need to ensure that Server1 downloads express installation files from the Microsoft Update servers.   What should you do from the Update Services console? Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 161-170

EnsurepassQUESTION 161 Your company has a main office and a branch office. The main office is located in Seattle. The branch office is located in Montreal. Each office is configured as an Active Directory site.   The network contains an Active Directory domain named adatum.com. The Seattle office contains a file server named Server1. The Montreal office contains a file server named Server2.   The servers run Windows Server 2012 R2 and have the File and Storage Services server role, the Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 141-150

EnsurepassQUESTION 141 Your network contains an Active Directory domain named contoso.com. The domain contains a domain controller named DC1 that runs Windows Server 2012 R2.   All client computers run Windows 8 Enterprise.   DC1 contains a Group Policy object (GPO) named GPO1.   You need to update the PATH variable on all of the client computers.   Which Group Policy preference should you configure?   A. Ini Files B. Services C. Data Sources D. Environment Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 131-140

EnsurepassQUESTION 131 Your network contains an Active Directory domain named contoso.com. All domain controllers run Windows Server 2012 R2.   On all of the domain controllers, Windows is installed in C:Windows and the Active Directory database is located in D:WindowsNTDS.   All of the domain controllers have a third-party application installed.   The operating system fails to recognize that the application is compatible with domain controller cloning.   You verify with the application Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 121-130

EnsurepassQUESTION 121 You have a server named Server1 that runs Windows Server 2012 R2.   You need to configure Server1 to create an entry in an event log when the processor usage exceeds 60 percent.   Which type of data collector should you create?   A. An event trace data collector B. A performance counter alert C. A performance counter data collector D. A configuration data collector   Correct Answer: B Explanation: Performance alerts notify you when a specified Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 111-120

EnsurepassQUESTION 111 Your network contains two servers named Served and Server 2. Both servers run Windows Server 2012 R2 and have the DNS Server server role installed.   On Server1, you create a standard primary zone named contoso.com.   You plan to create a standard primary zone for ad.contoso.com on Server2.   You need to ensure that Server1 forwards all queries for ad.contoso.com to Server2.   What should you do from Server1?   A. Create a trust anchor named Server2. Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 101-110

EnsurepassQUESTION 101 HOTSPOT Your network contains an Active Directory domain named contoso.com. The domain contains 30 user accounts that are used for network administration. The user accounts are members of a domain global group named Group1.   You identify the security requirements for the 30 user accounts as shown in the following table.     You need to identify which settings must be implemented by using a Password Settings object (PSO) and which settings must be implemented Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 91-100

EnsurepassQUESTION 91 Your company has a main office and two branch offices. The main office is located in Seattle. The two branch offices are located in Montreal and Miami. Each office is configured as an Active Directory site.   The network contains an Active Directory domain named contoso.com. Network traffic is not routed between the Montreal office and the Miami office.   You implement a Distributed File System (DFS) namespace named \contoso.compublic. The namespace contains a folder Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 71-80

EnsurepassQUESTION 71 Your network contains two Active Directory domains named contoso.com and adatum.com.   The network contains a server named Server1 that runs Windows Server 2012 R2. Server1 has the DNS Server server role installed. Server1 has a copy of the contoso.com DNS zone.   You need to configure Server1 to resolve names in the adatum.com domain. The solution must meet the following requirements:   Prevent the need to change the configuration of the current name servers Read more [...]
1 8 9 10 11 12 122