Which Transact-SQL query should you use?
A table named Profits stores the total profit made each year within a territory. The Profits
table has columns named Territory, Year, and Profit.
You need to create a report that displays the profits made by each territory for each year and
its previous year.
Which Transact-SQL query should you use?
You need to remove only Box from the list of applications only for this user
You administer an Azure Active Directory (Azure AD) tenant where Box is configured for:
Application Access
Password Single Sign-on
An employee moves to an organizational unit that does not require access to Box through
the Access Panel.
You need to remove only Box from the list of applications only for this user.
What should you do?
How should you configure MyApp’s manifest JSON file?
DRAG DROP
You publish a multi-tenant application named MyApp to Azure Active Directory (Azure AD).
You need to ensure that only directory administrators from the other organizations can
access MyApp’s web API.
How should you configure MyApp’s manifest JSON file? To answer, drag the appropriate
PowerShell command to the correct location in the application’s manifest JSON file. Each
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.
Which two actions should you perform?
You administer an Azure Active Directory (Azure AD) tenant that has a SharePoint web
application named TeamSite1. TeamSite1 accesses your Azure AD tenant for user
information.
The application access key for TeamSite1 has been compromised.
You need to ensure that users can continue to use TeamSite1 and that the compromised
key does not allow access to the data in your Azure AD tenant.
Which two actions should you perform? Each correct answer presents part of the solution.
Which Transact-SQL operator should you use?
You use Microsoft SQL Server 2012 database to develop a shopping cart application.
You need to rotate the unique values of the ProductName field of a table-valued expression
into multiple columns in the output.
Which Transact-SQL operator should you use?
What are two possible ways to achieve this goal?
You administer a DirSync server configured with Azure Active Directory (Azure AD).
You need to provision a user in Azure AD without waiting for the default DirSync
synchronization interval.
What are two possible ways to achieve this goal? Each correct answer presents a complete
solution.
Which Transact- SQL query or queries should you use?
You administer a Microsoft SQL Server database that supports a shopping application.
You need to retrieve a list of customers who live in territories that do not have a sales
person.
Which Transact- SQL query or queries should you use? (Each correct answer presents a
complete solution. Choose all that apply.)
Which settings should you configure to meet the requirements?
HOTSPOT
You manage an Internet Information Services (IIS) 6 website named contososite1.
Contososite1 runs a legacy ASP.NET 1.1 application named LegacyApp1. LegacyApp1
does not contain any integration with any other systems or programming languages.
You deploy contososite1 to Azure Web Sites.
You need to configure Azure Web Sites. You have the following requirements: LegacyApp1
runs correctly. The application pool does not recycle. Which settings should you configure to
meet the requirements? To answer, select the appropriate settings in the answer area.
Which data type should you use?
You are developing a database that will contain price information. You need to store the
prices that include a fixed precision and a scale of six digits. Which data type should you
use?
Which Transact-SQL query should you use?
You support a database structure shown in the exhibit. (Click the Exhibit button.)
You need to write a query that displays the following details:
• Total sales made by sales people, year, city, and country
• Sub totals only at the city level and country level
• A grand total of the sales amount
Which Transact-SQL query should you use?