70-764

DRAG DROP You have a SQL Azure database named Database1. You need to design the schema for a table named table1. Table1 will have less than one million rows. Table1 will contain the following information for each row: The solution must minimize the amount of space used to store each...

You need to move a database in between servers. You need to guarantee database users will be able to login in the database with a minimum of management effort.A . Application roleB . Database userC . Server loginD . Server roleView AnswerAnswer: B

You have a query that is used by a reporting dashboard. Users report that the query sometimes takes a long time to run. You need to recommend a solution to identify what is causing the issue. What should you recommend? More than one answer choice may achieve the goal. Select...

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...

A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Databaseinstances. The environment hosts several customer databases. One customer reports that their database is not responding as quickly as the service level agreements dictate. You observe that the database is fragmented. You need to optimize query performance....

You create an availability group that has replicas named HA/Server01 and HA/Server02. Currently, HA/Server01 is the primary replica. You have multiple queries that read data and produce reports from the database. You need to offload the reporting workload to the secondary replica when HA/Server01 is the primary replica. What should...

You administer a Microsoft SQL Server 2016 database instance. You plan to migrate the database to Windows Azure SQL Database. You verify that all objects contained in the database are compatible with Windows Azure SQL Database. You need to ensure that database users and required server logins are migrated to...

You are designing a monitoring application for a new SQL Server 2014 instance. You need to recommend a solution to generate a report that displays the 10 most frequent wait types that occur for the instance. What should you include in the recommendation? More than one answer choice may achieve...

You administer a single server that contains a Microsoft SQL Server 2016 default instance on which several production databases have been deployed. You plan to install a new ticketing application that requires the deployment of a database on the server. The SQL login for this application requires sysadmin permissions. You...

You administer a Microsoft SQL Server 2016 instance. After a routine shutdown, the drive that contains tempdb fails. You need to be able to start the SQL Server. What should you do?A . Modify tempdb location in startup parameters.B . Start SQL Server in minimal configuration mode.C . Start SQL...