DRAG DROP You have a server that has SQL Server 2016 installed. You need to configure native SQL Server backups for a database named Customers. The solution must use backup encryption. Which three actions...
You administer a Microsoft SQL Server 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...
Topic 1, Exam Pool A You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that an OLTP database that includes up-to-the-minute reporting requirements can be off-loaded...
HOTSPOT You have a server named SQL1 that has SQL Server 2014 installed. SQL1 has 32 processor cores and 64 GB of RAM. SQL1 hosts a database used for a public-facing marketing website. SQL1...
You administer a Microsoft SQL Server environment. The environment contains a SQL Server Reporting Services (SSRS) instance. You need to ensure that users can create subscriptions. What should you configure?A . cache refresh optionsB...
DRAG DROP You administer a Microsoft SQL Server database. You use an OrderDetail table that has the following definition: You need to create a non-clustered index on the SalesOrderID column in the OrderDetail table...
You are migrating a database named Orders to a new server that runs Microsoft SQL Server 2012. You attempt to add the [CorpnetUser1] login to the database. However, you receive the following error message:...
You are the data steward for a Business Intelligence project. You must identify duplicate rows stored in a SQL Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge...
You administer a Microsoft SQL Server environment. The environment contains a SQL Server Reporting Services (SSRS) instance. You need to ensure that users can create subscriptions. What should you configure?A . item security for...
You administer a Microsoft SQL Server failover cluster that contains two nodes named Node A and Node B. A single instance of SQL Server is installed on the cluster. An additional node named Node...
