- All Exams Instant Download
Which permission should you grant?
A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Databaseinstances. The environment hosts a customer database named DB1. Customers connect to hosted database instances by using line-of-business applications. Developers connectby using SQL Server Management Studio (SSMS). You need to grant the developers permission to alter views...
Which technologies should you identify?
DRAG DROP You are designing a database for a university. The database will contain two tables named Classes and Enrollment that have the following specifications: Classes will store brochures in the XPS format. The brochures must be structured in folders and must be accessible by using UNC paths. Enrollment will...
What should you do?
You administer a Microsoft SQL Server 2016 database that has multiple tables in the Sales schema. Some users must be prevented from deleting records in any of the tables in the Sales schema. You need to manage users who are prevented from deleting records in the Sales schema. You need...
Which three actions should you perform?
Background Corporate Information Fabrikam, Inc. is a retailer that sells electronics products on the Internet. The company has a headquarters site and one satellite sales office. You have been hired as the database administrator, and the company wants you to change the architecture of the Fabrikam ecommerce site to optimize...
What should you recommend?
Your company has offices in Seattle and Montreal. The network contains two servers named Server1 and Server2 that have SQL Server 2012 installed. Server1 is located in the Seattle office. Server2 is located in the Montreal office. The latency of the WAN link between the Montreal office and the Seattle...
What should you recommend?
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...
What should you include in the recommendation?
Overview Application Overview Contoso, Ltd., is the developer of an enterprise resource planning (ERP) application. Contoso is designing a new version of the ERP application. The previous version of the ERP application used SQL Server 2008 R2. The new version will use SQL Server 2014. The ERP application relies on...
Which backup option should you use?
You administer a Microsoft SQL Server 2016 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics: A data file of 2 terabytes is located on a dedicated LUN (drive D). A transaction log of 10 GB is located on...
Which of the following would be the most suitable secure storage solution?
You work as a Database Administrator (DBA) for a company named ABC.com. The company has a Windows Azure subscription. The company uses a cloud based SQL Server environment hosted on SQL Azure. Developers in your company are creating an ecommerce website. You are designing a database for the website. The...
Which Transact-SQL batch should you use?
You administer a Microsoft SQL Server 2016 database that contains a table named OrderDetail. You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You need to reduce fragmentation. You need to achieve this goal without taking the index offline. Which Transact-SQL batch should you use?A . CREATE INDEX NCI_OrderDetail_CustomerID ON...
