Microsoft Provisioning SQL Databases은 Microsoft의 공인 역량을 입증하는 자격으로 취업과 이직 시장에서 높은 가치를 인정받습니다. Fast2test의 70-765 모의고사 268문항으로 체계적으로 준비하여 자격 취득에 한 걸음 더 가까워지시기 바랍니다.

Microsoft 70-765 시험 개요:

Microsoft 70-765 시험 요강 주제:

Microsoft 70-765 관련 궁금증 해결 가이드

최신 MCP 70-765 무료샘플문제

문제 #1

Database DB1 must use two CPU cores.
Queries that were running on database DB2 prior to migration do not complete.
You need to configure the databases.
In the table below, identify the parameter that must be configured for each databases.
Select one option for DB1, and one option for DB2. Select one option for each column.

문제 #2

You need to resolve the identified issues.
Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.

문제 #3

You are a database developer of a Microsoft SQL Server 2014 database. You are designing a table that will store Customer data from different sources. The table will include a column that contains the CustomerID from the source system and a column that contains the SourceID. A sample of this data is as shown in the following table.

You need to ensure that the table has no duplicate CustomerID within a SourceID. You also need to ensure that the data in the table is in the order of SourceID and then CustomerID. Which Transact- SQL statement should you use?

A. CREATE TABLE Customer(SourceID int NOT NULL,CustomerID int NOT NULL PRIMARY KEY CLUSTERED,CustomerName varchar(255) NOT NULL);
B. CREATE TABLE Customer(SourceID int NOT NULL PRIMARY KEY CLUSTERED,CustomerID int NOT NULL UNIQUE,CustomerName varchar(255) NOT NULL);
C. CREATE TABLE Customer(SourceID int NOT NULL,CustomerID int NOT NULL,CustomerName varchar(255) NOT NULL,CONSTRAINT PK_Customer PRIMARY KEY CLUSTERED(SourceID, CustomerID));
D. CREATE TABLE Customer(SourceID int NOT NULL IDENTITY,CustomerID int NOT NULL IDENTITY,CustomerName varchar(255) NOT NULL);

문제 #4

Note: This questions is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You deploy Microsoft SQL Server to a virtual machine in Azure. You distribute the database files and filegroups across multiple Azure storage disks.
You must be able to manage the databases as individual entities by using SQL Server Management Studio. All data in the databases must be stored encrypted. Backups must be encrypted by using the same key as the live copy of the database.
You need to secure the data.
What should you implement?

A. transport-level encryption
B. Encrypting File System
C. cell-level encryption
D. BitLocker
E. dynamic data masking
F. Transparent Data Encryption
G. Always Encrypted

문제 #5

You administer a Microsoft SQL Server 2014 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 Windows Azure SQL Database.
What should you do?

A. Backup the database from the local server and restore it to Windows Azure SQL Database
B. Use the Database Transfer wizard
C. Use SQL Server Management Studio to deploy the database to Windows Azure SQL Database
D. Use the copy database wizard

질문과 대답: