Which query should you use?
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?
You need to ensure that the scripts are executed on new VMs
You develop a set of Power Shell scripts that will run when you deploy new virtual machines
(VMs).
You need to ensure that the scripts are executed on new VMs. You want to achieve this goal
by using the least amount of administrative effort.
What should you do?
Which stored procedure option should you use?
You are a database developer at an independent software vendor. You create stored
procedures that contain proprietary code.
You need to protect the code from being viewed by your customers.
Which stored procedure option should you use?
Which Azure Power Shell cmdlet should you use?
You manage a virtual Windows Server 2012 web server that is hosted by an on-premises
Windows Hyper-V server. You plan to use the virtual machine (VM) in Azure.
You need to migrate the VM to Azure Storage to add it to your repository.
Which Azure Power Shell cmdlet should you use?
Which three actions should you perform?
You administer of a set of virtual machine (VM) guests hosted in Hyper-V on Windows
Server 2012 R2.
The virtual machines run the following operating systems:
Windows Server 2008 Windows Server 2008 R2 Linux (openSUSE 13.1)
All guests currently are provisioned with one or more network interfaces with static bindings
and VHDX disks. You need to move the VMs to Azure Virtual Machines hosted in an Azure
subscription.
Which three actions should you perform? Each correct answer presents part of the solution.
Which Transact-SQL statement should you use?
You use a Microsoft SQL Server 2012 database.
You want to create a table to store Microsoft Word documents.
You need to ensure that the documents must only be accessible via Transact-SQL queries.
Which Transact-SQL statement should you use?
What should you do from the Management Portal?
You administer a virtual machine (VM) that is deployed to Azure. You configure a rule to
generate an alert when the average availability of a web service on your VM drops below 95
percent for 15 minutes.
The development team schedules a one-hour maintenance period.
You have the following requirements:
+ No alerts are created during the maintenance period.
+ Alerts can be restored when the maintenance is complete.
You want to achieve this goal by using the least amount of administrative effort.
What should you do from the Management Portal?
Which Transact-SQL batch should you use?
You administer a Microsoft SQL Server 2012 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?
You need to reduce the storage costs associated with the VMs
You manage an Azure subscription with virtual machines (VMs) that are running in Standard
mode.
You need to reduce the storage costs associated with the VMs.
What should you do?
Which Azure Power Shell cmdlets and values should you use?
DRAG DROP
You administer an Azure Virtual Machine (VM) named CON-CL1. CON-CL1 is in a cloud
service named ContosoService1.
You want to create a new VM named MyApp that will have a fixed IP address and be hosted
by an Azure Datacenter in the US West region.
You need to assign a fixed IP address to the MyApp VM.
Which Azure Power Shell cmdlets and values should you use? To answer, drag the
appropriate cmdlet or value to the correct location in the PowerShell command. Each cmdlet
or value may be used once, more than once, or not at all. You may need to drag the split bar
between panes or scroll to view content