- All Exams Instant Download
You deploy a Microsoft SQL Server instance to support a global sales application. The instance includes the following tables: Table A and Table B
HOTSPOT You deploy a Microsoft SQL Server instance to support a global sales application. The instance includes the following tables: Table A and Table B. TableA is a partitioned table that uses an incrementing integer number for partitioning. The table has millionsof rows in each partition. Most changes to the...
How can you achieve this goal?
You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL Server 2012. The Sales department uses a database named SalesDB. SalesDB contains a large table named Orders that lists every order ever received by the company. You want to improve...
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...
Which feature should you use?
You plan to install a Microsoft SQL Server 2016 instance. The instance will support a database that has the following requirements: Store Excel workbooks on the file system. Access the workbooks through Transact-SQL. Include the workbooks in database backups. During installation, you need to ensure that the requirements will be...
What should you recommend?
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...
What should you do?
You need to address the requirements for disc usage monitoring for the SQL Servers. What should you do?A . You should configure disc quotas.B . You should configure a Dynamic Management View.C . You should configure alerts sent by the SQL Server Agent.D . You should configure a SQL Server...
Does the solution meet the goal?
You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail. Solution: You add the DatabaseMailUserRole to Mail1 in the msdb database. Does the solution meet the goal?A . YesB . NoView AnswerAnswer: A Explanation: Database Mail is...
Which three actions should you perform in sequence?
DRAG DROP You administer a database that is used for reporting purposes. The database has a large fact table that contains three hundred million rows. The table includes a clustered columnstore index and a nonclusteredindex on the ProductID column. New rows are inserted into the table every day. Performance of...
What should you do?
Your company has a SQL Azure subscription. You implement a database named Database1. Database1 has two tables named Table1 and Table2. You create a stored procedure named sp1. Sp1 reads data from Table1 and inserts data into Table2. A user named User1 informs you that he is unable to run...
Which code segment should you execute?
You have a SQL Server 2012 database named DB1. You have a backup device named Device1. You discover that the log file for the database is full. You need to ensure that DB1 can complete transactions. The solution must not affect the chain of log sequence numbers (LSNs). Which code...
